Pattern Matching using LIKE predicate on a DB2 column using INDEX

govindrjujare

I have a column in db2 with an index. When I search using LIKE
predicate,
sometimes it gives results very slow (about 3 to 5 mins). But after
the initial hit,
subsequent searches using different expressions return very fast (2
secs).

It is almost as-if DB2 decides to cache the whole index when we run
the
query first time.

After couple of hours later (or next day) again the initial query
takes the hit.

Any ideas ?

Nov 7 '07 #1