Re: Index on Year of date field

Stephan Schaefer <stephan.schaefer_at_camline.com> wrote:
> I have a table with an index on the date field.
> And I have a view created by:
> create view myview
> as select col1,to_char(date_col,'YYYY') year
> from mytable ;

> Can I create an index on the date field so that selecting
> by year that index is used?
 

> Stephan Schaefer
> stesch_at_camline.com

I am afraid you will have to select between efficiency and convenience. Don't use view, put to_char in every query and say ' date_col between ...1997... and ...1998....

Konstantin Received on Wed Mar 04 1998 - 00:00:00 CST