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: Query Optimizer Fixes
Database Scoped Configurations in SQL Server 2016 and SQL Server 2017
We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with Database Scoped Configurations feature of …
Read More »