Answer / swapna

Statistics determine the selectivity of the indexes. If an
indexed column has unique values then the selectivity of
that index is more, as opposed to an index with non-unique
values. Query optimizer uses these indexes in determining
whether to choose an index or not while executing a query.

Some situations under which you should update statistics:
1) If there is significant change in the key values in the
index
2) If a large amount of data in an indexed column has been
added, changed, or removed (that is, if the distribution of
key values has changed), or the table has been truncated
using the TRUNCATE TABLE statement and then repopulated
3) Database is upgraded from a previous version

Answer / koti

Statistics determine the selectivity of the indexes. If an
indexed column has unique values then the selectivity of
that index is more . Query optimizer uses these statistics
in determining whether to choose an index or not while
executing a query.

To update statistics there is command :

update_statistics

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is the difference between a unique key and primary key?

0 Answers  

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

Explain about link server in sql server?

0 Answers  

---

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

Can we call stored procedure in view in sql server?

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

What is the purpose of indexing?

0 Answers  

---