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
