Re: Close to a million records & query too slow
Rick, you're a genius man! This query was running for 1 min 0.76 sec and now it runs for only 0.04 sec. It's unbelievable what my ignorance was costing me!
Again, thank you Rick, I do appreciate your assistance.
--
Sabelo
Subject
Views
Written By
Posted
6287
March 03, 2010 01:49PM
2481
March 04, 2010 10:09PM
Re: Close to a million records & query too slow
2273
March 08, 2010 03:36PM
1926
March 08, 2010 04:12PM
2312
March 09, 2010 09:20PM
1959
March 11, 2010 01:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.