Subject Re: [Firebird-Architect] Re: Things to consider?
Author Martijn Tonies
> >5. The ability to turn off the 'bitmapping' of multiple indexes.
> - 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.

Turning this OFF on an index means it can never be used. Does
that strike you as useful?

Wouldn't it be better to fix the optimizer of index performance (see
Firebird 2)?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!