| Nested for loop cursors or Joins???? [message #56717] |
Fri, 18 April 2003 14:45  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
I have been using around seven tables out of which am fetching rows from three tables.Here the tables are having around 25 lakhs records.I am using 'join' to extract specific rows from the above mentioned three tables satisfying the JOIN conditions.
So this procedure took around 2 hrs to complete.I have index created for all tables.But
I have modified the query with the cursors,it took around 1 hr 40 mins to complete.
But i still want to improve the throughput time to less than 1 hr.
So how can i proceed????
WHich one will be giving better performance(JOINs or CURSORS)...If i use cursor i should use nested for loop cursor for the three tables...
Please guide me in this regard...
Thanks
~V~
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
