Within the party of the tie, added documents beyond the final document of that tie, as laid out in the Purchase BY clause, might be included in The end result set. SQL Indexes An index is a schema item. It is employed by the server to hurry up the retrieval of rows by making use of a pointer.