Database Indexing

An Execution Plan are the steps the database needs to perform to execute a query, and for that there needs to be an appropriate access to the data. Most databases use index only. An index is an ordered representation of the indexed data. An index and a query are related and always have to go…