Wednesday, September 18, 2013

Performance issue with selection of data on a table

Your query plan looks optimal.



  • How big is this table (in megabytes)?

  • Are you running the query from a client machine? If so, what is your network speed?

  • How much data does this query have to send over the network?


The questions above are to establish whether your expectation of speeding up this query is realistic.




Gert-Jan


No comments:

Post a Comment