Introduction

The duty of a DBA is not finished by just creating an index on necessary fields. Actually, the DBA's duty of keeping database performance high starts at the point of creating a the necessary index.

From time to time, the DBA needs to keep an eye on some very important points, mentioned as follows, with regards to the index, because index maintenance is on-going task and needs the attention of the DBA.

• Fragmentation level of index

• Missing index

• Unused index