Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »
Tag Archives: table scan
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 »