what is index in database and how to create it in database

 CREATE INDEX idx_lastname

ON Persons (LastName);

An index is a database structure that you can use to improve the performance of database activity