Satya, I thought "why not!". You have some good SEO pointing to that topic and the extra info on updating stats and recompile might help someone out...
Indexdefrag does NOT update stats. You need to run: UPDATE STATISTICS TableName WITH FULLSCAN -- WITH FULLSCAN is an option Remember also: EXEC...
Separate names with a comma.
