RE: Problem with SQL peformance-depends on field in Where Clause!

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

"one of the keys", or the FIRST key? If PIPPO is a secondary key, the
logical isn't going to do you much good. Given your timings I'd say that
in both cases you're missing an index you could use. With a simple sql
like that, if there is an index on the single field you're using in the
where clause you should get subsecond response time, always! If you're
not, something's wrong w/the indicies.

Walden's General Rule of SQL: Simple selects are _always_ subsecond! A
14-way join w/"LIKE" processing and non-optimal indicies take longer.

-Walden

------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)