Vander Clock Stephane wrote:

> thanks sven, but unfortunatly yes it's this : the result set contain
> million of records:(
> with the index it's can return in few milliseconds, without it's can
> return in few seconds that s unaceptable for us ...

And the client needs to see all of them at once?
The point SET is trying to make is "why do you need all the results at once?"
In my own applications, the result set is 'paged' so you only need enough to
fill the page ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php