Database System - Index Selection (10 points) Consider the following table of all the state residents CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255), Age integer with the following indexes. INDEX1: Clustered sparse B-+ tree index on (LastName, FirstName) INDEX2: Clustered dense hash table index on (LastName, FirstName) INDEX3: Unclustered hash table index on Age INDEX4: Unclustered B+ tree index on Age INDEX5: Unclustered hash table index on City For each of the given predicates, describe which index is the best to pick and why it' s the best? Note that you can choose no index and do a full scan on the table if you think it will outperform using any indexes 1. Age > 25 AND Age Valley City' (4 points) For part 3, note that Valley City is the least populated city in the state