Re: Index over DB2 table question

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

--
IBM i on Power Systems - For when you can't afford to be out of business
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.