Introduction An Execution Plan is composed by the steps that the optimizer does in order to process a SQL statement. Oracle Optimizer always tries to find out the best execution plan for a SQL stateme...
Introduction When a SQL statement is issued, the server process, after checking its syntax and semantics, searches the library cache for an existing cursor for the SQL statement. If a cursor does not ...
Hi, This blog comes from the e-mail bag. [:)] One of my followers asks two useful questions that a novice to relational databases or an end user/power user is likely to have. The questions relate to ...
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, Sharding is a method of having a widely distributed database across various hardware platforms utilizing a mix of database technologies. Sharding extends partitioning to various distributed databa...
Introduction Before Oracle 12.1.0.1, whenever a table partition was dropped all the global indexes that were created on that table became UNUSABLE unless we specified the clause UPDATE INDEXES in the ...
Introduction Oracle Database Resource Manager enables you to limit database resources. Oracle has been enhanced in this regard in its new versions; for example, in 12.1.0.1, Database Resource Manager ...
Introduction A covering index is a special case of an index in InnoDB where all required fields for a query are included in the index; in other words, the index itself contains the required data to ex...
Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn't require as much monitoring and tuning, but there...
En un artículo anterior hemos aprendido cómo crear una cuenta en Amazon Web Services (AWS), además de conocer lo que es Amazon RDS y finalmente aprendimos cómo configurar una Instancia de la base de d...
En este artículo vamos a dar una vista general de esta aplicación llamada PhpMyAdmin la cual es una de las aplicaciones más populares para la gestión de bases de datos MySQL. A lo largo de mi carrera ...
Introduction Information technology is one of the key areas which keep changing drastically and we should be ready to accept these changes as per the moving trend. These changes will help enterprise o...
