In this article, we discuss a feature of the Oracle Database that you can include in your arsenal: materialized views. Originally called snapshots, materialized views were introduced in Oracle8i and are only available in the Enterprise Edition. Like a regular view, the data in a materialized view results from a query. However, the results of a […]
Read More
Knowing how to select appropriately between SQL-based and PL/SQL-based solutions is one of the most important skills in Oracle database development. Let’s look at two less common examples of using PL/SQL in actual systems development. The first example illustrates the notion of performance tuning by going outside of the regular solution patterns, while the second […]
Read More
The prior article finished the discussion on hard parsing. This article will take a look at some of the explain plan content then wrap up with what to look for when you have poorly performing SQL. Up to now, we have been discussing how Oracle processes SQL, the hard and soft parse processes, and how […]
Read More
The prior article started a discussion on the hard parsing process. It left off with the query transformation step. Please read these articles in the proper order as they each build on the prior article. The next step in the hard parse process is the permutations, as shown in the Figure below, taken from the […]
Read More
If you’re database professional, you continuously face the challenge of improving database performance. Throwing hardware at the problem is a common solution to slow performance. And this approach often focuses on procuring SSD storage, servers, or CPU. But is ‘throwing hardware at the problem’ the right solution or is it just a big gamble? We […]
Read More
Performance troubleshooting is one of the unique challenges every developer and DBA has to face. One of the major complaints about performance troubleshooting is utilization of resources. Few organizations resort to putting muscle power to scale up the system without analyzing the root cause of the performance problem. For example, a typical scenario might involve a SQL Server instance with memory […]
Read More
Recently, I heard a story that was quite compelling. A retired naval officer used to get to the top of a bridge and keep waving his hand everyday around 8 PM. The passer-by used to think the elderly man had gone nuts and, after awhile, ignored his actions. One fine day, a stranger saw this and was […]
Read More
Lately, the big IT buzzword is cloud solutions. In fact, if you believe all of the hype, most companies are moving en masse from on-premise solutions to cloud-based architectures. On the surface, the cloud-based solution certainly seems to be a more affordable solution that not only reduces the complexities of on-premise build-outs and maintenance, but […]
Read More
Working with SQL Server is always a challenge. As developers try to troubleshoot SQL Server performance problems, the first step that take is to look at the queries. This is the most basic step and most important step for most developers. Developers love these challenges of optimization because they can get the maximum visible performance improvements in their […]
Read More
Learn from Oracle experts about the myths and realities of what causes poor Oracle database performance and tips for improving it.
Read More
SQL Server and database experts share insights on features of SQL Server 2014 that promise significant performance potential.
Read More
SQL Server and database experts share insights on how to assess performance issues, including closely examining wait types to determine root cause.
Read More