Article View: borland.public.interbase.sql
Article #409Re: Smart indexes
From: Bill Todd [TeamB]
Date: Mon, 03 Mar 2008 11:58
Date: Mon, 03 Mar 2008 11:58
6 lines
1132 bytes
1132 bytes
Try creating two indices. One on the columns in the ON clause (on both tables) and one on o.Pot. Then look at the plan and see how the indices are being used. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<47cbf5ed$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<47cbcc24@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,ae9de598b62dbfeb
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: Smart indexes
Newsgroups: borland.public.interbase.sql
References: <47cbcc24@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
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
NNTP-Posting-Host: 65.118.176.23
Message-ID: <47cbf5ed$1@newsgroups.borland.com>
Date: 3 Mar 2008 04:58:21 -0700
X-Trace: newsgroups.borland.com 1204549101 65.118.176.23 (3 Mar 2008 04:58:21 -0700)
Lines: 6
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail