Multiple choice technology databases

In Accounts_History table, among many columns, I have the Account_ID (Primary Key) and Trans_Date. There is a query that runs frequently to know the latest transaction that was done on the account. Which one of the below approaches will be most beneficial in this case?

  1. Defining a clustered index on Account_ID

  2. Defining a clustered index on Account_ID, Trans_Date

  3. Defining a non-clustered index on Account_ID, Trans_Date

  4. Don't define any indexes
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Because the query frequently needs the most recent transaction per account, a clustered index on (Account_ID, Trans_Date) stores rows in that order, enabling fast retrieval of the latest date for a given account without additional sorting. A single‑column index or a non‑clustered index would be less efficient.

Keep practicing — related questions