Indexing-Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes , they are just used to speed up searches/queries.

Sql join-A join clause is...read more