What is data automation Data automation is the process whereby a series of repetitive steps used to upload, transform or otherwise handle data can be scripted and reused. The resulting automation scri...
Can’t find time for SQL performance tuning? Reliant on overstretched DBAs who don’t have a spare minute? Don’t let your queries slow down the database. Learn how to optimize SQL query — in minutes. ...
SQL performance tuning is the focus of this blog and video tutorial series. First in a three-part series, we'll highlight features in our different editions of Toad for Oracle, starting with Base (Exp...
DID you know that TOAD comes with a ton of code templates? These templates often have substitution variables as well. CTRL+ Space bar signals ALL of the templates. You can type in a template name,...
Hi, This article hopes to compare Toad v13.0 and SQL Developer v18.1 a bit. Since I work with both tools in my training business, people often ask me to point out the differences in the two. I hope to...
Hi,This article will discuss some PL/SQL performance tuning tips as well as make reference to a variety of good coding practices. There are several things you can do to get your PL/SQL code to run op...
This article will discuss the CASE statement. PL/SQL has had the CASE statement since Oracle9 I believe (an eternity for most of today’s coders). I will also illustrate a little-known fact: The CASE...
Hi, I just wrote an article (click here to see article) that illustrates how B-Tree indexes work. Basically, they store key values that are to be looked up in their associated table. So, key values ...
Hi, Oracle12 introduced a new database architecture for the Oracle database: multi-tenant or pluggable databases. The basic concept is a container database (CDB) that can contain one or more pluggabl...
Hi, I have a lot of knowledge about how Oracle’s indexes work. I’ll start with how Oracle B-tree indexes work, as well as syntax and practical uses for each. Oracle B-Tree Index Structure The abo...
Hi, Did you know that Oracle supports compression in various forms in the database? You can compress an entire tablespace (all of its contents), a table, or part of a table (at the partition level). ...
Hi, There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning cours...
