As we have seen in an earlier article for the easiest way to access data in databases we use indexes and statistics. Indexes are essentially an index that helps us find what we are looking for faster. But as... read more
How do we find the longest running queries in an Oracle database
In Oracle databases we have the ability to find statistical data for queries using the ASH and AWR reports. But to activate this feature we must have Enterprise version. At Standard we can do… read more
Why doesn't SQL Server use all CPU Cores?
Having a SQL Server Instance installation we can face the following strange situation, while there is a need for CPU usage that never reaches this 100%. In the article we will see what may be the reason and how... read more
How to see what operations a query performs to complete it in SQL Server (Execution Plan Operators)
To run a query on SQL Server, the Query Optimizer takes information such as the query, database schema, statistics and derives the optimal way to access them. The result is called Plano or otherwise… read more
How to improve the performance of a query running on an Oracle database (SQL Tuning Advisor)
Many times we will hear that suddenly a query that was running fast suddenly started to run slow or that a query is running very slowly for no reason. The easiest way to find out what is wrong and solve it is with… read more
What is Query Store and how we use it in SQL Server
Query Store appeared from SQL Server 2016 onwards. It is a tool provided so that we can track each query in the database. Through the Query Store we can see a query... read more
How do we find what queries are running in an Oracle database?
Many times the need will arise to quickly look for a session that executes a query. We might want to see the plan it ran with, the memory it consumes, the sql text, the session id, if… read more
How to force a plan in an Oracle database
In a previous article we saw why a query can run with a different plan and how to force one in SQL Server. In this article we will see how to force a plan in an Oracle database with... read more
How do we find what's slowing down queries in SQL Server?
Many times we will see that a query is delayed and we would like to know what is delaying it. To do this we need to know the wait types and what each of them means. Specifically… read more
