midrange-l-request@xxxxxxxxxxxx wrote:

>   1. Re: Query optimizer tells me to build an access path that
>      already   exists (Clare Holtham)
>
>That's one of the indexes you ALWAYS want to build.

This subject does show a glimpse of the differences between PFs/LFs and 
tables/views/indexes. I've seen that if an LF is created over a PF and both 
share the same key, then the LF file description shows the PF as owning the 
access path. But a SQL CREATE INDEX using the same field doesn't appear to 
share the existing PF access path; it seems that a brand new one is created. 
(There might be ways of getting LFs and SQL indexes to coincide better, but I 
haven't learned them.)

Two obvious considerations come to mind -- double access-path maintenance and 
double space for storing the access paths.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Introducing the New Netscape Internet Service. 
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need. 

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.