Question: Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Answer: Looks like index page split has occurred. DO a REORG of the indexes.
Looks like index page split has occurred. DO a REORG of the indexes. Source: CoolInterview.com
Rules to Post Answers in CoolInterview.com:- There should not be any Spelling Mistakes. There should not be any Gramatical Errors. Answers must not contain any bad words. Answers should not be the repeat of same answer, already approved. Answer should be complete in itself.
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.