Re: Foreign key & User defined Index Difference

Article View: borland.public.interbase.sql

Article #472

Back to borland.public.interbase.sql Previous Next

#472

From: Bill Todd
Date: Mon, 03 Dec 2007 21:46

22 lines
1607 bytes

Quinn Wildman (CodeGear Developer Support) wrote:

> The optimizer used to have priority level something like this:
> 
> 1. keys
> 2. unique indexes
> 3. foreign keys
> 4. indexes with highest selectivity
> 
> I belive it is now:
> 
> 1. keys
> 2. unique indexes
> 3. indexes with highest selectivity

That matches my understanding. What that says is that in older versions
of InterBase foreign key indexes may be used even though their
selectivity is low. That was a well documented problem. Your wording
confused me. Thanks.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <47548732$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<474fc025$1@newsgroups.borland.com> <47507fad@newsgroups.borland.com> <475085be$1@newsgroups.borland.com> <47543f72$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,e8cd02e29a9aa333
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Foreign key & User defined Index Difference
Newsgroups: borland.public.interbase.sql
References: <474fc025$1@newsgroups.borland.com> <47507fad@newsgroups.borland.com> <475085be$1@newsgroups.borland.com> <47543f72$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 65.118.176.23
Message-ID: <47548732$1@newsgroups.borland.com>
Date: 3 Dec 2007 14:46:10 -0700
X-Trace: newsgroups.borland.com 1196721970 65.118.176.23 (3 Dec 2007 14:46:10 -0700)
Lines: 22
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message