You could index the pri key.
There are two major products that come out of Berkeley: LSD and [Unix] BS D. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Tracy Bost" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 8:21 AM Subject: Speeding up select queries > What is the best approach to speed up "select" statements with a sql200 0 > database? The data is constantly being updated,deleted,inserted, throug h out > the day with each user seeing data depending on his/her access level an d > assigned zip codes. I worry that using cachedwithin will not work in th is > senario, as using that will not allow to show data that has recently changed. > ANY help, thoughts much appreciated. > > ----------------------------------------------------------------------- --- ---- > Visit "The Most Powerful Tool on the Farm" at http://www.ifarm.com > Get the latest on Ag News, Market Reports, FREE email, and much more. > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists