Performence Tuning

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi,

I am running a batch query it is very slow in SQL 7.0 than SQL 6.5 what could be the problem.

The batch query consists select statements with where clauses. And i have done indexing also.

Thanks, Ravi.

-- Anonymous, October 09, 2001

Answers

Ravi,

This usenet posting by Neil Pike, "SQL 6.5 Performance vs SQL 7.0 Performance" may provide some answers.

http://groups.google.com/groups? hl=en&rnum=6&selm=VA.00002fdc.01367142%40neilpikeport

(Be sure to type the URL all on one line with no spaces.)

Good Luck,

Eric

-- Anonymous, October 09, 2001


Moderation questions? read the FAQ