>Hi Bruce,
>
>Try:
>
>- Not use SELECT *
>Do like this: SELECT keyfield ....
>
>Check out results!
>
>- OR do the follwing:
>
>SELECT keyfield from table1 into array1
>SELECT keyfield from table2 into array2
Thanks, Ricardo, but I have already tried these things, or similar.
I tried selecting only the keyfield, like
SELECT keyfield FROM...but it takes just as long as * (all fields) - and I need the entire record, anyway.
I also tried similar to your array idea, but with two cursors holding only the keys (remember, these are very large and will not fit into an array). But that too is extremely slow. I'm looking for some way to use the indexes, but it's possible there is no quick way to do this...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.