sp_helpindex 'Customer'
It allows to identify whether the 'Customer' table has any indexes
It allows to identify whether the 'Customer' table has any indexes
(Tip from Basic Execution Plans - http://www.youtube.com/watch?v=lvnCRhgfyV0)
sp_helpstats 'Orders'
It shows whether the 'Orders' has a statistics
sp_helpstats 'Orders'
It shows whether the 'Orders' has a statistics
No comments:
Post a Comment