![How to Find Size of All the Indexes on the Database - Interview Question of the Week #097 - SQL Authority with Pinal Dave How to Find Size of All the Indexes on the Database - Interview Question of the Week #097 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2016/11/indexsize.jpg)
How to Find Size of All the Indexes on the Database - Interview Question of the Week #097 - SQL Authority with Pinal Dave
![The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes. The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes.](https://use-the-index-luke.com/static/sqlserver-clustered-logical-reads.en.XlWynw6P.png)
The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes.
![What to Do When the Index is Larger Than the SQL Table | by Sascha Peter Bajonczak | Better Programming What to Do When the Index is Larger Than the SQL Table | by Sascha Peter Bajonczak | Better Programming](https://miro.medium.com/max/904/0*UDJIZdaBMxWkNw7O.png)