I keep reading that I should make sure that all of my queries are optimized
and indexed and I know that SQL 7 comes with a query optimizer. What I don't
understand is how you can build indexes and optimize the dynamic queries that
CF uses.
Do I pick a constant in place of the variable and optimize against that and
then put the variables back in after optimization?
Thanks,
Ian
____________________________________________________________________
Get your own FREE, personal Netscape WebMail account today at
http://webmail.netscape.com.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
