Interested to Buy Any Domain ? << Click Here >> for more details...
what is statistics
- 1 Answers
- 4269 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 |
Plz tell about backup&recovery?
What value could be assigned to Varchar Type?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Can we rewrite subqueries into simple select statements or with joins? Example?
What is the difference between char, varchar and nvarchar?
What are the differences between stored procedure and view in sql server?
What is data source object?
How to create a simple user defined function in ms sql server?
What do you mean by cardinality?
List down some advantages of sql stored procedure?
What are the functions in sql server?
Write down the syntax and an example for create, rename and delete index?
-
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)
