I recently posted a question on the Database Administrators Stack Exchange platform that I believe aligns with the expertise of your community. The question revolves around the size difference between a composite index and a default index on the 'ID' column. The link to the question is provided below:
I am eager to hear any thoughts or explanations you might have regarding this observed size difference. Have you encountered similar scenarios, and do you have any recommendations or explanations for this phenomenon?