Database Tips

Database Tuning, SQL Execution Plan and Query Rewrite

In a previous post, we present an introduction to database tuning. In this post, we’ll talk about SQL execution plans[…]

Database tuning is a key activity of DBA professionals. It consists on making (or suggesting) performance oriented changes, which may[…]

Are PostgreSQL and Ingres related? What MariaDB, MySQL and Infobright have in common? What is the origin of Microsoft SQL[…]

Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]

Non-correlated subqueries (where the inner query does not have any column from the outer query tables) are usually implemented using[…]

Python has become one of the most popular programming languages and is used in various contexts, including in WEB applications[…]

LEAD and LAG are window functions that enable the simultaneous access to a table’s row and to other row related[…]

There are a lot of options to use when testing for NULL values in SQL. One should use built-in functions[…]

In most of application databases, we can find one or more numeric columns representing IDs or used as primary keys.[…]

Let’s take a look on how to send mail in Oracle DBMS using the UTL_SMTP package in a step-by-step basis:[…]