> > Then again, who needs wide indices if expression indices are supported.

:-)

>
> What are ``expression indices''?

Indices based on an expression that returns a value instead of being
based on column values.

I haven't tried it, but imagine something like:

create index index_name on table mytable
( upper(mycolumn) )

or

create index index_name on table mytable
( substring(mycolumn, 1, 100) )

So you could, for example, index the first 100 characters of a longish
column instead of the full column value.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com