Problem w/ SQL Performance

[PeteAmsterdam]

I face this strange problem when I run this query in
STRSQL.


SELECT * from kldadbfi3/norio10l WHERE PIPPO = '220215'

This query takes 10 seconds to return the results (just 1
record which satisfies )

Where as the query

SELECT * FROM kldadbfi3/norio10l WHERE nnureg= 662631
Takes only 3 seconds


Both these queries selects the same record ...means NNUREG =
662631 & PIPPO = '220215' are of the same record

Norio10l is a logical file with PIPPO as one of the keys.



Does the SQL discriminate between the field that is used in
the WHERE clause?


TIA,
Pete

 

[vongrunt]

This is DB/2 stuff?

3 seconds for one record is still slow...

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)