Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!sjc70.webusenet.com!news.usenetserver.com!border1.nntp.sjc.giganews.com!nntp.giganews.com!local1.nntp.sjc.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Fri, 23 Apr 2004 11:44:09 -0500 Reply-To: "Laconic2" From: "Laconic2" Newsgroups: comp.databases.theory References: <407d5b68.12958493@news.wanadoo.es> <407e7725.5656954@news.wanadoo.es> <407fb4d1.1060625@news.wanadoo.es> <$Aj4L5DCMrhAFwEQ@thewolery.demon.co.uk> Subject: Re: Date's First Great Blunder Date: Fri, 23 Apr 2004 12:45:02 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: Lines: 9 NNTP-Posting-Host: 24.60.68.134 X-Trace: sv3-w7OGHWc++tuPLHLw93xwdLCa4qsb3uUzO/f1iW4foJg9b73+HKkuy2pFuM4B7YnWHCI6r735oQ6qffC!ofr80rPC68mfB1jXp3EGsQi3/RHxzuIyyIaDPN1o2OkBsHZHwuAW5bewvJMR X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.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:25852 It gets worse. What if you wanted to scan by the order items that all ordered the same product. You would have to do a complete scan, unless you had an index to help you find what you are looking for quickly.