Consider the following table of all the ILLINOlS 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 Age40 (3 points) 2. FirstName'Abdu' AND LastNameAlawini' (3 points) 3. City 'Valley City' (4 points) For part 3, note that Valley City is the least populated city in Illinois. Consider the following table of all the ILLINOlS 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 Age40 (3 points) 2. FirstName'Abdu' AND LastNameAlawini' (3 points) 3. City 'Valley City' (4 points) For part 3, note that Valley City is the least populated city in Illinois