Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In this article, we will examine the join types in the execution plan. Before you read this article, you can get more from this …
Read More »
Tag Archives: nonclustered index
Differences Between Primary Key and Unique Constraint
If you are reading this article, you should read my articles “What is Primary Key And Foreign Key” and “What is Unique Constraint” at first. …
Read More »
SQL Server Indexes and Performance Effect
This article contains information about SQL Server indexes and performance effetc of indexes. What is Index in SQL Server? Indexes allow us to access data …
Read More »
Differences Between Clustered Index and Non Clustered Index
To better understand this article, I would first recommend reading the “Index Concept and Performance Effect on SQL Server” and “Statistics Concept and Performance Effect …
Read More »