If you do a runstats on table x with distribution and indexes all you will
use the index unless the table is too small.

You dont need to tell db2 to use the index, it knows the best path if you
do the runstats.




"Daniel Andres Manque Paineo "
<db2udbdba-ezmlmshield-x94819095.[Email address protected]
08/24/2007 01:28 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Use index for db2?






How I can do a query sql for db2 forcing the search for a specific index?
Select * from t1 using index1 where a=xxxx?

example please :(

trank's!!


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page