Question

Does anyone know of an application that optimizies
queries? I have downloaded Lecco Expert for ms sql but got
gypte because its for oracle... dont know if they even
have for sql server. Does anyone know of any application?
thanxsI am sure Leccotech have a version for SQL Server too. There are tools like
Veritas Indepth, that can identify poor performing and long running queries.
You could do the same using Profiler, which comes free with SQL Server.
Then, SQL Server also comes with Index Tuning Wizard, that can help you tune
your indexes.
As far as optimizing queries is concerned, I'd much rather prefer a skilled
DBA doing that job, than a tool.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"CS" <anonymous@.discussions.microsoft.com> wrote in message
news:063c01c3d3b0$ecda4c20$a001280a@.phx.gbl...
Does anyone know of an application that optimizies
queries? I have downloaded Lecco Expert for ms sql but got
gypte because its for oracle... dont know if they even
have for sql server. Does anyone know of any application?
thanxs