Re: Function Based indexes

How about:

Index on the financial week of corresponding to a date so that the users can query for 'all days in week 43 of this year compared to week 43 of last year' without having to find out what those dates are ?

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Mike Burden wrote in message <374556BB.3354AB5B_at_capgemini.co.uk>...
>Function based indexes seem really interesting (ok so I'm sad) but I
>have seen very little written about them (i.e. Thomas Kyte's article).
>
>So far I have gathered three useful features that can be implemented
>using them:
>
>1) Uppercase indexes (as described in TK's article)
>2) Composite key index search from a given key using greater than (e.g.
>MyCompKey(x,y,z) > MyCompKey('a','b','c')
>3) Sparse indexes (i.e. were you require only certain values for non
>unique indexes to reduce long chains).
>
>Can anyone think of any other good uses.
>
Received on Mon May 24 1999 - 14:39:44 CDT