Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!news-out.superfeed.net!propagator2-maxim!news-in.superfeed.net!tethys.csu.net!newshub.sdsu.edu!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.golden.net!news.golden.net.POSTED!not-for-mail NNTP-Posting-Date: Tue, 11 Nov 2003 10:34:01 -0600 From: "Bob Badour" Newsgroups: comp.databases.theory References: <6278687.0311110830.215f56ac@posting.google.com> Subject: Re: Utility of indexes Date: Tue, 11 Nov 2003 11:33:27 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Lines: 14 NNTP-Posting-Host: 207.35.144.158 X-Trace: sv3-HfKi5MYDwhZOktdy3Eo5ksBgqIHA5NmsZGfsfE9p60bH55f/MgmtxR/bm9gyw6Mj8ioD3VBDWWO66AP!EcjJTcAZwY4YmxxWhJovbI52THZq/hz4F94hCsxgkNs2wVr7bUBV9OeztXTeZfn7IERAsA8lLQ== X-Complaints-To: abuse@golden.net X-DMCA-Complaints-To: abuse@golden.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: newssvr20.news.prodigy.com comp.databases.theory:22626 "Juan Pardillos" wrote in message news:6278687.0311110830.215f56ac@posting.google.com... > Hi, > > I have an attribute in a table that I know the number of different > values it can take is small. However, there are lots of tuples in the > table. Does it make sense to define an index on that attribute? > > Thanks in advance It probably won't help to have an index on just that attribute, but it might prove valuable as part of a compound index.