Interested to Buy Any Domain ? << Click Here >> for more details...
what is statistics
- 1 Answers
- 4294 Views
- I also Faced
- E-Mail Answers
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 |
How to create user messages with print statements in ms sql server?
Can another user execute your local temporary stored procedures?
How to select nth record from a table?
13 Answers DELL, Microsoft, Ramco,
How to attach adventureworkslt physical files to the server?
How to how to convert numeric expression data types using the convert() function??
Does sql server 2016 have ssms?
What is the use of keyword with encryption.
How would you choose between a clustered and a non-clustered index?
Explain activity monitors
How do I find the sql server database version?
What are the differences between union, intersect, and minus operators?
What is snapshot replication?
-
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)
