Hello,

Is it possible to use index when we have to use only the clause ORDER ? (I needn't to use the clause WHERE)

Can we have the possibility to use an index with the clause "ORDER" ?

Example :
Select *
from view
order by a, b, c

I would like tio create an index ordered like a,b, c

Yes, and DB2 will probably use the index and avoid a sort.

Andy

Most likely db2 will use an index ...

There may be occasions(based on statistics, of course) when there may be a tablescan ...

I assume the columns a.b and c in the view are not based on functions ...

HTH

Sathyaram

Yes, DB2 may decide to use an index in lieu of a sort. But there is no guarantee, and DB2 will use what it thinks is fastest based on the query and the statistics from a runstats.

Can we force the use of an index ? I have 250000 records and the system doesn't take it (IBM AS400 V5R1)

Not sure about AS400 ...

But what is the definition of the table and view ?

I assume you have done RUNSTATS ...

Cheers
sathyaram