Re: AW: DDL Discussion continued

Vern, et al,

Where I get my info there is a difference between a LF that may be an access path and an true index created by the CREATE INDEX command, is from how they look in the system and via Navigator. I"m also not sure a LF is constructed underneath like an index either but you all probably know more about that.

When I take a look at a logical file it seems to have a structure, much like a PF. You can see actual data. When I take a look at an index, I don't see the same thing. The LF also doesn't seem to have the same page size, the index being much bigger. It seems in a LF, you can have SQL to create a view and therefore do things that don't seem to be available with an index. It appears a LF can be accessed via a program to sort and present the data to a program in a different way than how the data exists in a PF. An index is accessed "under the covers" and from what I can see, can't be accessed directly by a program. Just some of the differences I see.

On the system I work on, there a MANY LFs/access paths but they don't show up as indexes via Navigator but an index does.

That, coupled with the traditional use of an index in a relational database vs. a VIEW (LF to you all) makes them different animals. Why are my observations so different between the two but yet you all say they are the same? What am I missing?

Dave