Request to incorporate the page density (avg_page_space_used_in_percent) as a determining factor in deciding whether or not to rebuild the index. Given that we are using modern solid-state drives, fragmentation alone does not provide a comprehensive view of our system’s state. By considering page density, we can make more informed decisions about index rebuilds, leading to improved system performance and efficiency.
Request to incorporate the page density (avg_page_space_used_in_percent) as a determining factor in deciding whether or not to rebuild the index. Given that we are using modern solid-state drives, fragmentation alone does not provide a comprehensive view of our system’s state. By considering page density, we can make more informed decisions about index rebuilds, leading to improved system performance and efficiency.