@Andrew Lopez,

By turning off Index advisor, I am expecting optimizer to work with
existing indexes even if they are not ideal indexes. It should stop
identifying ideal indexes and stop calculating access path costs based on
non existing indexes. This will definitely reduce optimization cost.



This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].