Interested to Buy Any Domain ? << Click Here >> for more details...
what is statistics
- 1 Answers
- 4226 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 |
Why would you use sql agent?
How to execute a sql statement using odbc_exec()?
What is nolock hint in sql server 2008
Why I have to use stored procedures?
what is a self join? Explain it with an example? : Sql server database administration
Differentiate between ms sql server reporting services vs crystal reports?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What are differences in between sql server 2012 and sql server 2016?
How do you know if sql server is running on your local system?
Explain transaction server explicit transaction?
How to create an index on an existing table in ms sql server?
What is model database? : SQL Server Architecture
-
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)
