hi,

i have created an index on a table as
create index on table ( C1||C2||C3)

and i fired a query
select /*+indexhint too */.....where (C1||C2||C3)=(X||y||Z)

but the explan plan shows full table scan...

am i missing something???

thanx in adv
sanjay