April 13, 2010 at 11:40 pm
Hi Experts,
We are having database that contain more than 100 tables and 200 million records in total. We are creating indexes on some tbles having millions of records as per the recommendations from execution plans.
Do we need to check anything in particular?
What are all the steps to do before and after creating indexes?
TIA
April 14, 2010 at 3:18 am
do you mean recommendations from the tuning advisor?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2010 at 3:20 am
No sir :-D,
I mean update the other existing statistics,rebuilding or reorganising indexes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply