HOME

Tip 75 - Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE

To improve the performance of your code that uses numerous table variables, consider …

TYPE Definition Change in Oracle 21c

Oracle 21c now offers the possibility of using some PL/SQL data types in …

Tip 74 – Changing Cost Threshold for Parallelism

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer …

Is COUNT(rowid) Faster Than COUNT(*)?

It is believed that count(*) expands to all columns and that count(rowid) is …

How Many Databases Can You Name?

There is a huge number of databases available. How many could you name? Create our list …

How to Find the Estimation Cost for a Query

Discover how to estimate the cost of a query. Read on to see an example of how to …

Understanding Views in SQL

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

Introduction to Azure SQL Database Instance Pools

Learn about Azure SQL Database Instance Pools and how they they set to provide more …

A Look at the Oracle Group-by Bug

In Oracle 12.2 and later a group-by elimination enhancement can produce wrong results. …

Creating or Altering an Objects with a Single Statement

Do you get tired of having your CREATE PROCEDURE statement failing if the stored …

Considerations for Deploying Azure SQL Database Managed Instances

Microsoft provides a number of different deployment options for its Azure SQL Database …

Working with SQL Cursors

In SQL cursors serve as a pointer that enables application programming language to deal …

Connecting to a MySQL Database in .NET

Learn how to connect to a MySQL database from a .NET application.

Adding Data to a Cloud Firestore Database

Learn how to add data to a NoSQL Cloud-based database (Firebase Firestore) from a …

Introduction to Firebase

If you are doing a mobile or web-based app that need scalable access to a scalable, …