79560418

Date: 2025-04-07 16:59:37
Score: 1.5
Natty:
Report link

Check the number of rows vs clustering factor

select index_name, num_rows, clustering_factor from dba_indexes where index_name = <your index>;

If clustering_factor is > num_rows, the underlying table is fragmented so the index has a high clustering factor. Consider setting a clustering directive for the table, reorganize the table by doing an online move, and then rebuild the index.

https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/attribute-clustering.html#GUID-CFA30358-183D-4770-9A79-C6720BF9D753

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Mike Lawson