Run a trace on that db saving the trace data to a file while you run your app then run the index tunning wizard
-----Original Message----- To: CF-Talk <[EMAIL PROTECTED]> From: Jochem van Dieten <[EMAIL PROTECTED]> Subject: Re: Need to optimise query performance Date: Wed, 26 Jun 2002 13:44:39 +0200 Vishal Narayan wrote: > 3. Performance tuning at DB level and database optimisation: > I've already tried the following : > - primary keys for all tables in use > - indexes on all columns used for joins > Is there anything else I can do towards performance tuning ? Could I use > views to reduce the load on my SQL 2000 DB ? Delete the candidatemaster.cat_id1, candidatemaster.cat_id2 and candidatemaster.cat_id3 columns and use a separate table to connect the candidatemaster table to the category table. That should do away with the need for outer joins and other unwelcome constructions. Jochem ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
