Why index is used in database schema? Consider the following relational schema employees (emp id, name, email, phone) wh
Posted: Wed Mar 30, 2022 9:23 am
Why index is used in database schema? Consider the following relational schema employees (emp id, name, email, phone) where, emp_id is the primary key. Write SQL to create index for the columns: email and phone