Kbase P24360: A SQL92 query with an IN predicate that contains alarge number of values (more than 200) runs extrem
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/03/2010 |
|
Status: Unverified
SYMPTOM(s):
A SQL92 query with an IN predicate that contains a
large number of values (more than 200) runs extremely slowly.
A subquery in the IN predicate runs relatively quickly
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
A work around at present is to put the elements of the IN predicate into a table and use a subquery in the IN predicate