Database Management & Programming News, Articles & Tutorials for Database Administrators

Tip 75 - Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE 04/01/2021

To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE.

TYPE Definition Change in Oracle 21c 03/04/2021

Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions.  Read on to see what types are available and how to use them.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).

Tip 74 – Changing Cost Threshold for Parallelism 02/24/2021

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer will consider using plans that will go parallel.

Is COUNT(rowid) Faster Than COUNT(*)? 05/18/2020

It is believed that count(*) expands to all columns and that count(rowid) is faster.  Read on to see why the opposite might be true.

How Many Databases Can You Name? 05/11/2020

There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!

How to Find the Estimation Cost for a Query 05/04/2020

Discover how to estimate the cost of a query. Read on to see an example of how to extract the Estimated Cost for execution plans stored in the procedure cache.  

Understanding Views in SQL 04/27/2020

Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.

Introduction to Azure SQL Database Instance Pools 04/20/2020

Learn about Azure SQL Database Instance Pools and how they they set to provide more flexibility and agility than other Platform-as-a Service SQL Server-based offerings in Azure.

A Look at the Oracle Group-by Bug 04/13/2020

In Oracle 12.2 and later a group-by elimination enhancement can produce wrong results. Read on to see what can be returned and how to work around it.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).