On Tue, 2004-03-30 at 18:08, Vern Hamberg wrote:
> AFAIK, physical files are not the same as flat files. They ARE the same as 
> tables created through the SQL CREATE TABLE statement.
> 

Not entirely true. For example, there are two code paths used for
selecting from a table scan.

If you are selecting on a numeric value, and that table was built with
DDS, then the optimizer is forced to use the 'Derived field' selection.
If the table was built with SQL, then the table scan can use the Direct
selection. The code path is shorter on the Direct selection.

> And keyed logical files and SQL indexes are essentially the same thing - 
> B-trees.

The Access Path part is, but most keyed logical files show up as views,
even when no mapping takes place. And sometimes, they don't even show up
as views. But the optimizer still considers non-sparse access paths
during the optimization phase.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.