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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.