sql - What really 'STATISTICS' do? -

-

what statistics do? , where use in query optimization senarios?

you not manually use statistics. sql server's query optimizer does. used determine if , indexes query.

at point, recommend start reading basics:


Comments

Post a Comment

Popular posts from this blog

Delphi Wmi Query on a Remote Machine -

-
we use wmiset wmi queries on remote machines. works in delphi 2007 not available delphi xe. i found code wmi queries previous question use wmi delphi . code snippet provided in answer no. 5 works on local machine, need know if possible execute wmi query on remote machine. even if connect remote machine administrator credentials, eolesyserror: access denied exception. regards, pieter. pieter. before connect remote machine using wmi must enable dcom access specified user in remote machine. read these articles understand , fix problems connecting remote machines using wmi. securing remote wmi connection connecting wmi remotely starting windows vista troubleshooting error code 80070005 - access denied (great page find solution connections problems) additionally here leave more clear code connect wmi in remote machine. check part eoleexception exception processed error code , found cause of issue. program wmiremote; {$apptype console} uses sysutils,...
Read more