27.02.2018 17:19, Rashid Abzalov wrote:
And what about enable/disable the regular system indexes?
Without this capability, system queries will continue to use regular
system indexes, instead of more suitable (for performance reasons in
specific cases) user indexes.
It's up to the optimizer to decide what indices should be used in every
particular case, it doesn't distinguish between system and user-defined
indices. If your index matches better, it will be used.
Also, most internal queries are cached after prepare, so (1) indices
already used cannot be disabled and (2) plans cannot change after some
index is enabled.
So I don't see much practical sense in allowing disable/enable for
system indices.
Dmitry
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
