What is an Index?


An Index is a key built from one or more columns in the database that speeds up fetching rows from the table or view. This key helps a Database like Oracle, SQL Server, MySQL, etc. to find the row associated with key values quickly.
Two types of Indexes are:
  • Clustered Index
  • Non-Clustered Index

No comments:

Post a Comment