RE: Query optimizer tells me to build an access path that already exists

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