Statistics on SQL2005

It appears that outside of statistcs name, sql server allows you to create
duplicate statistics. How does sql server handle statistics update when this
happens?

Also, is there a difference in having single create statistics statement for
two columns compared to two create statistics statements for one column each?

Thanks in advance

Hello RG,

This you should really ask in a SQL newsgroup/forum:
http://www.microsoft.com/communities...&lang=en&cr=us

http://social.msdn.microsoft.com/For...ory/sqlserver/

Choose one newsgroup from the left pane which comes nearest for your needs.


Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm


> It appears that outside of statistcs name, sql server allows you to
> create duplicate statistics. How does sql server handle statistics
> update when this happens?
>
> Also, is there a difference in having single create statistics
> statement for two columns compared to two create statistics statements
> for one column each?
>
> Thanks in advance
>