Uh, oh. That smells like trouble. Are these 8 brands in separate fields in the table? If so, that's probably bad. You probably should pull that off into a 1-many linked table instead.
Or do you mean something else? -----Original Message----- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 13:30 To: SQL Subject: Re: I need some indexing advice I have about 8 brands that can be searched on. So, should I make one index that includes all 8 brands? I think I should but I want to check first. Phillip B. www.LoungeRoyale.com www.FillWorks.com ----- Original Message ----- From: "Raster, Tim" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 11:32 AM Subject: RE: I need some indexing advice > Yup. And look for opportunities to index multiple fields within an > index, if both are commonly searched. > > Others may disagree with me here, but I usually follow the philosophy > of, "When in doubt, index it." It's usually only in very extreme > (highly transactional) cases that the index will hurt. If your database > is fairly static, then index the crap out of it. > > > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 11:25 > To: SQL > Subject: Re: I need some indexing advice > > I should have also mentioned that part of the where clause is what brand > they sell. Should I consider indexing the brand fields as well since > that is > a common search criteria? > > Phillip B. > > www.LoungeRoyale.com > www.FillWorks.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
