Couldn't you also add an index to your date column?
Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 8:00 AM Subject: Improve Query > This query is taking alittle long, anyone help me try and make it faster? The table (in sql server) has approx. 500,000 records and is indexed by and idnumber field. > > SELECT COUNT(PAGE) AS PAGE_COUNT, PAGE > FROM tblpage_requests > WHERE (DATED BETWEEN '06/1/02' AND '06/18/2002') > GROUP BY PAGE > ORDER BY PAGE_COUNT DESC > > thanks > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
