Re: Really weird question

On 16 Aug 2001, aj739_at_FreeNet.Carleton.CA wrote:

>
> I have a table with approximately 6000 rows in an 8.1.7
> database on an HP UX server.
>
> I run a query SELECT COL1 FROM TABLE1;
>
> Then I run a new query SELECT COL1, COL2 FROM TABLE1; The rows
> are in exactly the same order as when I ran the first query.
>
> Next I run the query SELECT COL1, COL2, COL3 FROM TABLE1;
> The rows are no longer in the same order.
>
> Does anyone have an explanation of why this happens?

Are col1 and col2 part of an index? Maybe the first two queries are retrieving from cache where the third one has to go back to disk?

-- 
Galen Boyer
It seems to me, I remember every single thing I know.