I think that would be a "view" not an "index".

CREATE TABLE QTEMP/ASHISH (MYDATE DATE NOT NULL WITH DEFAULT,
MYDATA CHAR (5 ) NOT NULL WITH DEFAULT)

INSERT INTO QTEMP/ASHISH VALUES(current date, 'test')
INSERT INTO QTEMP/ASHISH VALUES(date('2011-01-31'), 'test')

CREATE VIEW QTEMP/ASHISHV1 AS SELECT * FROM qtemp/ashish WHERE
mydate=current date

select * from qtemp/ashishv1

MYDATE MYDATA
2011-05-20 test

This will not work
CREATE INDEX QTEMP/ASHISHi1 ON QTEMP/ASHISH (MYDATE)
where mydate=current date

This will:
CREATE INDEX QTEMP/ASHISHi1 ON QTEMP/ASHISH (MYDATE)
where mydate=date('2011-05-20')

Which I am willing to guess you do not want.

You could combine it with
CREATE INDEX QTEMP/ASHISHi1 ON QTEMP/ASHISH (MYDATE)
and
CREATE VIEW QTEMP/ASHISHV1 AS SELECT * FROM qtemp/ashish WHERE
mydate=current date

That way you get the performance benefit of an index with the selection of
a view.


Rob Berendt

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].