|Subject||Re: [Firebird-Architect] Re: Things to consider?|
> >5. The ability to turn off the 'bitmapping' of multiple indexes.Turning this OFF on an index means it can never be used. Does
> - You've given us a prospective solution but left the problem
> - unstated. Give us the problem. Maybe there's a better solution.
> My (possibly flawed) understanding is that this is a mechanism where
> multiple indexes are 'merged' (where possible) when deciding/executing
> a query. Often it works to good and intended effect but occasionally
> it results in inhibited performance.
that strike you as useful?
Wouldn't it be better to fix the optimizer of index performance (see
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!