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.

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).