what is statistics
Answer / sam
statistics in SQL Server refers specifically to information
that the server collects about the distribution of data in
columns and indexes. This data in turn is used by the query
optimizer to determine the plan of attack for returning
results when you run a query. While in the majority of
cases SQL Server takes care of this statistical
recordkeeping for you automatically, it's useful to have
some understanding of what's going on, and to know when you
might need to intervene.
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain in brief about Microsoft SQL server?
What is the difference between the application object and session object?
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
What is the difference between mysql and sql server?
What do I need to start working with sql studio? : sql server management studio
How do I start sql server 2017?
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
What is the STUFF function and how does it differ from the REPLACE function?
How to find out the list schema name and table name for the database?
How to call stored procedure using http soap?
Can we hide the definition of a stored procedure from a use?
can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)