This tips covers optimizing SQL statements that use a VIEW in place of a TABLE. In early versions of the Oracle database, a VIEW was handled like a temporary table that stores the temporary data from...
This tip covers the importance of finding the best “driving path” for retrieving rows from the database. We’ll use a simple illustration of a Nested Loop operation that retrieves data accessing 2 tab...
This tip covers how to specify the table join syntax which is used when SQL alternatives are generated. When the syntax for SQL statements was originally developed, the conditions of joining tables w...
This tip covers testing the SQL alternatives in a development environment when it is not possible to do extensive testing in the production environment. When optimizing a SQL statement, you need to t...
This tip covers executing SQL statements that require you to enter a parameter before the SQL statements are executed. A SQL statement with a variable which is provided at run time poses an extra chal...
When writing a SQL statement, it is easy to be satisfied when you have figured out how to get the correct results. This is especially true when you are writing a complicated SQL statement. But in orde...
This tip covers why the run time of a SQL statement may vary from one execution to the next. When you execute a SQL statement several times in Quest SQL Optimizer, you may notice that the run time wi...
Normal system backups, referred to as either Hot or Cold backups, are used to protect from media failure. A Cold backup, that is, one done with the database in a shutdown state, provides a complete co...
DB2 allows stored procedures to be developed in a variety of ways. Stored Procedures can be based on a programming language such as C, C++, Java, or SQL PL. Stored Procedure creation and registration ...
Stored procedures can be written in a variety of languages, including C, C++, Java, and SQL PL. SQL PL is a language specifically designed for DB2 and offers a rich set of features that can make it su...
Q: How do I change my connection color? A: In Toad for Oracle 11: Click on a connection in the log-in window. Scroll over to the Color column. Click within that field to access the list of colors. ...
Inspect SGA retrieves executed SQL statements from Oracle’s System Global Area or currently running SQL statements from Oracle’s open cursor. Once you retrieve the statements, Inspect SGA displays the...
