By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Pattern Matching using LIKE predicate on a DB2 column using INDEX

P: n/a

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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.