If you select query takes long time, do explain plan and see if there are any full table scans. If so and you already have index on those columns find out why they are not used.
The other thing to look is the table and index statistics. They have to be up to date for the Query Optimizer to make the right execution plan decisions. The script when and how to analyze the index and table statictics could be found Here