Re: Sorting records in Physical and Logical files

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Walden H. Leverich wrote:
> Yes, with a level of knowledge I'll never have or want. The number of
> rows in the table, the distribution of the values, the "busyness" of the
> machine, the availability of memory, these are but a few of the details
> that go into a query optimization.
Of course, a lot of that depends on the optimizer guessing correctly 
what you want, but that's what a query optimizer is supposed to do.  You 
just have to make sure you tell it correctly, and thus the requirement 
for things like QAQQINI.

>  I don't want to think about this
> stuff, I just want the orders for customer 22212 as fast as I can get
> them.
>   
And this makes sense.  Of course, if the requirement is "get me the 
customer master info for customer 22212 as fast as I can gget it" then 
the right tool *is* ISAM.

Joe