Indexing

CUSTOMER DI - Customers are most frequently searched by their first name and last name. - The table is also frequently joined with the ORDER table. - Often, the query outcomes are grouped by state. - The company wish to order the table by their last name. Discuss how you would like to design indexes for the table? We discussed the three types of index: primary, clustering and secondary. Explain your choice of indexes