I am having big performance problems afters applying SP3 for SQL Server 2000 Enterprise Edition.
We have a large query generated by Crystal Reports involving about 20 tables and views with joins and outer joins.
The largest table have 100000 rows and is 20 Mb large.
If I run this query on SQL server without service pack, it takes less than 1 second, with SP3 it takes more than 2 minutes!
I found a workaround, copying all data selectes by the larger view into a table and using the table instead of the view in the query.
I looked at execution plans and it seems an optimizer bug of SP3.
Someone could help me, please?Have you checked SP3a readme for any fix.|||Have you verified you applied SP3a NOT SP3?
SP3 had an Slow ODBC bug in the client part of it.
Tim S
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment