Re: Expressional Indexes

[sNip]
>> I have been considering using "calculated index" or "computed index"
>> but dunno if that really conveys anything.
>
> Well, "Expression Indexes" is the most accurate. Or "Expression-Based
> Indexes."

What is the proposed definition of an "Expression Index?"

When I see this term, I get the impression I can create an index that's
based on the results of a SELECT, such as for selecting data with specific
values or ranges of values...

For example, if I want to index on a date field but only have the index
keep track of the most recent 30 days (and then create a secondary index for
all dates) so as to improve performance on more heavily loaded systems.

Am I understanding this new terminology correctly? Thanks in advance.

--
Randolf Richardson - rr(at)8x(dot)ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.