priya

SQL or Structured Query Language is a language which is used to communicate with a relational database. It provides a way to manipulate and create databases. On the other hand, MySQL and Microsoft’s SQL Server both are relational database management systems that use SQL as their standard relational database language. MySQL is available for free … Read more

Non-Clustered Index: The reason to create non-clustered index is searching the data. We well know that clustered indexes are created automatically primary keys are generated, but non-clustered indexes are created when multiple joins conditions and various filters are used in the query. Non-Clustered Index does not alter the physical order of the table and maintains … Read more

Clustered Index: The clustered index is used to reorder the physical order of the table and search based on the key values. Each table can have only one clustered index. The Clustered index is the only index which has been automatically created when the primary key is generated. If moderate data modification needed to be … Read more

Unique Index: For creating a unique index, the user has to check the data in the column because the unique indexes are used when any column of the table has unique values. This indexing does not allow the field to have duplicate values if the column is unique indexed. A unique index can be applied … Read more

There are three types of Indexes in SQL: Unique Index Clustered Index NonClustered Index Bit-Map index Normal index Composite index B-tree index function based index In SQL, there are primarily three types of indexes: Clustered Index: Defines the order in which data is physically stored in a table. The table can have only one clustered … Read more