Ashish Kulkarni wrote:
I have a question about Index, i have table with date field in it, i would
like to create a index where this date is current date, is it possible to do
so?

Index or view?

Indexes are just access paths to a table.

View's provide alternate ways of viewing the data in one or more table ... including selection criteria.

Try something like this: CREATE VIEW myview AS SELECT FIELD1,FIELD2,FIELD3 where DATEFIELD = CURRENT DATE;

david


This thread ...

Follow-Ups:
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].