Yes, when you rebuild an index the table/index becomes available as soon as the index rebuild is completed.
Statistics based on the index rebuilt are updated when an index rebuild occurs, but SQL Server also allows you to create statistics on non-indexed columns and, if left at the default, will automatically create statistics on columns the optimizer thinks will help. These column level statistics are NOT updated when an index is rebuilt thus you need to update them.
I recommend using Ola Hallengren's maintenance scripts[/url] for this type of work. Michelle Ufford also has a good index maintenance script [/url]as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question