Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …
Read More »
Tag Archives: index scan
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 »