Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Can't we rely on execution plan for performance !!! Expand / Collapse
Author
Message
Posted Thursday, September 26, 2013 5:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 12:22 AM
Points: 43, Visits: 481
i personaly use statictics io and time io
for comparing two query.



===========================================
performance issue:
(1) Have you update the statistics on all tables of underling query?
(2) Are you using index well on the tables?
(3) Can you simplify your Query by re-writing it .
(4) are indexes are Defragmented well ?

Post #1498783
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse