Hi,

Can someone help me to find a way to reterive first 500 records from a query having 3 or more then 3 joins. By default query is returing more then 60000 records,and taking enough time to execute.
Is there any way in which oracle work to reterive first 500 records and should not work for rest of the records, so that query execution time can be much faster.

Thanx in advance.
Sukhveer Singh