Database Indexing allows us to cut down the number of rows/records that need to be examined when a select query with a where clause is executed.Let's try to understand what happens when a select query is executed on a database table without an index.Suppose we have an Employee table, with fields 'Employee_Id' and 'Employee_Name'. We … Continue reading Database Indexing Basics