SQL INDEX - Lab Exercise

Practice questions
1.Create table with index: • Name: Duplicate record • Contact: No duplicate record • Gmail: No duplicate record
2. How will you check the table size and index size?
3. How to find index: • Find index in table wise • Count of index • Find index in column wise

Practice questions

    1.Create table with index: 
       •	Name: Duplicate record
       •	Contact: No duplicate record
       •	Gmail: No duplicate record

    2. How will you check the table size and index size?

    3. How to find index:
       •	Find index in table wise
       •	Count of index
       •	Find index in column wise