What are the most common customer mistakes that can be avoided?
No Comments Posted for this Article.
Oracle: Common misconceptions
Some widely accepted information about the Oracle database is shown not to be entirely correct upon closer examination. 1. The Oracle cost-based optimizer always selects the...
Determine the most Critical SQL Statements
It is always good to determine the most exclusive SQL statements in terms of elapsed time and checking the result list top down, For a technical SQL optimization. The most expensive SQL statements in...
Oracle DUAL Table Avoid Hard Parsing
We have been asked to avoid hard parsing of the some SQL statements involving DUAL Table. For example 1 of the queries to avoid hard parsing is as follows SELECT COUNT(*) FROM DUAL where...