From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 8:36 AM
Subject: Re: SQL Query
<snip>
> Also, SQL provides the Index Tuning Wizard which allows you to select and
> create an optimal set of indexes.
>
> Cheers,
> Bill
</snip>
I agree.. typically I save all my web queries to a text file. Then go into
MS SQL Server and using the Index Tuning Wizard, create my indexes
from my individual SQL statements. The wizard will let you know if that
index exists already and give you benchmarks for SQL. Helpful.
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
