Queries(joins?) slow after applying sql2000 SP4.

  • We have a couple servers still running sql2000, we just upgraded one to SP4 from 8.00.2039, a simple query

    select * from person_time pt

    right join person_time_data ptd on pt.person_time_key=ptd.person_time_key

    where pt.person_time_key is null

    takes 37 seconds after the patch, we cloned the system to a VM prior to the upgrade and the same query takes 4 seconds there.

    Any insight would be helpful. how a server pack can effect joins?..

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply