Showing entries 1 to 1
Displaying posts with tag: indexes on internal temporary tables (reset)
Mar
08
2010
When indexes are created in internal temporary tables
Posted by Venu Anuganti on Mon 08 Mar 2010 11:40 UTC
Tags:

During my previous post on how to improve derived tables performance, I patched the code to add indexes forcefully on internal derived table results, which made a huge difference in the performance. It was just an experiment and a thought to see if it really works without re-writing the queries, so that the logic can [...]

Showing entries 1 to 1