Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 STATISTICS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-26 : 09:51:11
MuratA writes "I have a table which named defter1 and it contains 1 million records. And has a non-clus. index . Index has four keys (customernumber, accountid, agentnumber, customeraccountnumber).
When i exec sp_help defter1 i saw that there were no statistics created on first column(customernumber) of index. Altough the other index key statistics are created on this table. Could you explain why ?"
   

- Advertisement -