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.
| Author |
Topic |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2005-01-18 : 22:34:05
|
| Is it ok to have default option of auto update statistics enough.Also what does mean RANGE_HI_KEY mean.I quite didnt understand the defn provided by BOL.Can someone please explainthanks |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-18 : 23:41:59
|
| See if these help you:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbrowsets_special_purpose_rowsets.aspPay attention to the first article and the last few paragraphs of the second one. You should understand it pretty well after reading these articles. FYI, there are some really good free video tutorials on the Microsoft website about SQL Server indexing. I would definitely look at those if I were you.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Statistics