-
How to return first 500 records from a query having 3 or 4 joins
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|