index in sql

Index In sql :- An index is a schema object that can speed up the retrieval of rows by using a pointer. Indexes can be created explicitly or automatically. If we do mot have an index on the column, then a full table scan will occur. An index provides direct and fast access to rows in … Read more