J
jamesmc
Guest
On the surface there is nothing wrong with it (ignoring the SHARE-LOCK issue) so it should work nice and fast so something else must be slowing it down. Poor database design? (table in a type I area with really bad scatter?) Poor index availability? (all the data needs to be read and sorted first?) Or perhaps a large record size (lots of fields being sent to the client that are not needed?). How long does the query actually take to run as you havent mentioned that in your post?
Continue reading...
Continue reading...