Optimization to skip index dives with FORCE INDEX.

Optimization to skip index dives with FORCE INDEX.

Index dives are performed during the optimization phase to help decide which index to use. Currently when user specifies FORCE INDEX, optimizer still always calculates cost using index dives. Under some circumstances it is possible to avoid the index dives and this could speed up execution.…

Source: Optimization to skip index dives with FORCE INDEX.

About ILHA CHO 7627 Articles
지락문화예술공작단

Be the first to comment

Leave a Reply

Your email address will not be published.


*


Time limit is exhausted. Please reload CAPTCHA.