Why Do Oracle DB File Sequential Reads Show Up in a Full Table Scan?
There are four primary reasons why you see Oracle DB File Sequential Read wait events in a full scan operation. Learn more.
Read MoreMost Popular Performance Tuning
Minimizing Oracle db file sequential Read Wait Events
To minimize the Oracle db file sequential read waits you can optimize the SQL statement or reduce the average wait time. Learn more.
Read MoreUnderstanding the Oracle db file sequential read Wait Event
The Oracle db file sequential read wait event is initiated by SQL statements that perform single-block read operations. Learn when these waits may indicate a need for tuning.
Read MoreWhy is Historical Oracle Performance Data Important?
DBAs are often blamed for problems unrelated to the database. This article makes the case that a DBA’s strongest defense is access to session-level historical performance data.
Read MoreSQL Server Query Optimization–Understanding Statistics
Statistics provide critical information needed by SQL Server when performing query optimization, including details about the data and what the data looks like in each table within the database.
Read MoreSQL Server Query Optimization: Parallel Plans
Learn how SQL Server Query Optimizer chooses parallel plans–any plan in which the Optimizer splits as applicable operator into multiple threads–and how this can impact performance.
Read MoreSQL Server Query Optimization
Get a high-level overview of the secret inner workings of the SQL Server 2012 Query Optimizer.
Read MoreTuning SQL Server Memory, Part 2
Learn how using memory effectively in SQL Server 2012 can have a large impact on the system’s overall ability to scale and perform well.
Read MoreTuning SQL Server Memory, Part 1
Learn how using memory effectively in SQL Server 2012 can have a large impact on the system’s overall ability to scale and perform well.
Read MoreExpand the Buffer Cache to Reduce Physical Reads in an Oracle Database
Learn how exapnding the Oracle buffer cache can reduce physical reads and improve performance.
Read MoreThe Pivot Operator Is More than Just a Report Option
The PIVOT operator in SQL Server may help code readability and may shorten code implementation time. Learn how to use if effectively.
Read MoreFinding Usable Oracle Indexes
Learn how cleaning up unused indexes can impact Oracle performance.
Read More