Find index fragmentation in table

As a DBA, you often get question from developers and users- what is indexing and fragmentation? Well, in simple words indexing is the process of creating index in the table to enhance the performance of queries. Index is created as the subset of different columns in the table hence it is subset of indexed table. More frequent dml […]