| Subject | Expression based index |
|---|---|
| Author | sasidhardoc |
| Post date | 2006-07-19T22:08:43Z |
On Firebird 2.0, I have a table with ID, LastName. I want to be able
to do case insensitive searches - without creating a shadow column.
I have a expression based index like this:
CREATE ASC INDEX........... COMPUTED BY (upper(LASTNAME)
now, with real data, there may be a lot of duplicates on this column -
is it possible to create a compound index (LastName, ID) with
expression based indexes? TIA
to do case insensitive searches - without creating a shadow column.
I have a expression based index like this:
CREATE ASC INDEX........... COMPUTED BY (upper(LASTNAME)
now, with real data, there may be a lot of duplicates on this column -
is it possible to create a compound index (LastName, ID) with
expression based indexes? TIA