467,868 Members | 1,383 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,868 developers. It's quick & easy.

Pattern Matching using LIKE predicate on a DB2 column using INDEX


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
  • viewed: 2675
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

176 posts views Thread by Thomas Reichelt | last post: by
9 posts views Thread by Xah Lee | last post: by
5 posts views Thread by olaufr | last post: by
7 posts views Thread by Serge Rielau | last post: by
2 posts views Thread by Ole Nielsby | last post: by
1 post views Thread by VanKha | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.