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: index seek
What is Execution Plan in SQL Server
What is a execution plan in SQL? Execution plan is a road map that determines how the query will work. Will the query use the …
Read More »
SQL Server Statistics and Performance Effect
We will talk about SQL Server Statistics in this article. What is Statistics in SQL Server? When you execute a query on SQL Server, it …
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 »