• beginners SQL book will really help to understand the concept of Indexes.

    Like why only one clustered index per table

    When we say clustered index can also have non unique rows, so how sql manages to search a row.