The case for function based indexes – part two
Some time ago I wrote about function based indexes, showing a PostgreSQL based case, right now I’ll show a Firebird based example, due to the fact that Firebird 2.0 supports Expression Indexes, which are my good old function based indexes.
Read More on pabloj’s blog
Hi Mariuz, do you know if something about indexing is in the works for 2.x releases?
I mean something like ASC/DESC on the same index.
Thanks
Afaik, due to the nature of the way FB builds its indexes structure, it is impossible to have asc and desc in the same index.
Too bad 🙁
Thanks for the info