I have a question regarding indexes.
Why do we required to drop index on prodcution database and recreate it again. I have seen somany times, guys are talking about droping index and recreate.
Can any one explain, for what reason we need to drop the existing index and recreate it. Suppose i have table 10milion records and those record occupied 1 million of data blocks. Means 10 records are there in one block. Here i have create index on that table(10million records), how can we know howmany leaf blocks used for this index. Somany question here again :(
1) Actually what is leaf block and leaf entry.
Thanks & Regards,