How can I optimize SQL 6.5 ? 
Author Message
 How can I optimize SQL 6.5 ?
I know that with SQL 7 I can create index to database when I found slow
response to a select... into Diagram Wizard... when I check the
perfomance...

How can I optimize connection client - SQL 6.5  ?

Thanks

Celso



Sat, 15 Nov 2003 13:24:55 GMT
 How can I optimize SQL 6.5 ?

Celso,

I don't follow your reference to a "diagram wizard", could you please be a bit more
specific?

In 6.5, you can execute SET SHOWPLAN ON and SET STATISTICS ON to see the execution
plan and the cost. There's no index tuning wizard for 6.5, so you have to do the
analyze and test work manually.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com


Quote:
> I know that with SQL 7 I can create index to database when I found slow
> response to a select... into Diagram Wizard... when I check the
> perfomance...

> How can I optimize connection client - SQL 6.5  ?

> Thanks

> Celso




Sat, 15 Nov 2003 14:17:47 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ms SQL 6.5 Index optimizing question ???

2. Optimizing performance SQL server 6.5

3. Optimizing SQL 6.5 for thousands of tables

4. How to optimize SQL 6.5

5. Optimizing sql 6.5

6. Help needed optimizing SQL 6.5 for 5GB 39 million record database

7. ms SQL 6.5 Index optimizing question ???

8. ms SQL 6.5 Index optimizing question ???

9. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

10. How to revert back from SQL 6.5 SP5 to SQL 6.5 SP4

11. Install SQL 6.5 Srv Pck 3 for SQL 6.5 Workstation


 
Powered by phpBB® Forum Software