Function-based indexes in DB2

[leo6]

Hi ,

I have a DB2 SQL query like :

select a.col1,b.col1
from tab1 a, tab2 b
where a.col1=b.col1
and lower(a.col2) = <value>

how can i create an index on the function, lower(a.col2) so that the query uses the index.
currently index for a is on (col1,col2) but the query for a goes for a TBSCAN .

 

[SQLBill]

You need to post this in a Tek-Tips DB2 forum. This forum is specifically for Microsoft's SQL Server.

-SQLBill

Posting advice: FAQ481-4875

 

[NoCoolHandle]

I think you need to go to the DB2 Forum.

This is for MS SQLSERVER - A product by Microsoft not Big Blue.