OT: NoCOUG Journal article: How to avoid a salted banana! (SQL tuning)
From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Mon, 12 Jan 2015 17:06:15 -0800
Message-ID: <BLU179-W821250A2E3650A330637ABEB400_at_phx.gbl>
Download the latest issue of the NoCOUG Journal. Lothar Flatz talks about the biggest issue in SQL tuning: the “salted banana.” We predict that the phrase “salted banana” will become as widely known in the Oracle community as “compulsive tuning disorder.”Janis Griffin—a.k.a. the Looney Tuner—explains why the Oracle Database 12c “adaptive optimizer” is the best thing since sliced bread. The Oracle Database 12c query optimizer makes all previous versions of the query optimizer—and the query optimizers of Oracle competitors—seem primitive and foolish in comparison. All previous versions of the query optimizer stick to the plan, even when it is painfully, painfully obvious—after a few records have been retrieved—that the plan is terribly, terribly wrong. But why stick to a full table scan or an index scan if it becomes painfully, painfully obvious—after a few records have been retrieved—that there has been a terrible, terrible miscalculation and that the current plan is terribly, terribly wrong and should be abandoned, even though query execution has already started. If you were looking for a reason to upgrade to Oracle Database 12c, the adaptive optimizer is it.Guy Harrison talks up the five biggest trends in database technology. If you read his article, you will be able to respond intelligently when your CIO or enterprise architect asks you for your opinion.Iggy Fernandez explains why he doesn’t have a huge problem with the NoSQL fad. According to him, the NoSQL architecture is entirely compatible with the relational model and he points out that RDBMS vendors have already started incorporating these features into their products.Kyle Hailey provides a detailed explanation of the hottest topic in IT: thin provisioning of the entire tech stack—database as well as application. Business is dependent upon IT to deliver required applications and services but these applications and services are dependent upon timely, high-quality refreshes. Using thin provisioning, IT can deliver results faster, quicker, and cheaper.
Date: Mon, 12 Jan 2015 17:06:15 -0800
Message-ID: <BLU179-W821250A2E3650A330637ABEB400_at_phx.gbl>
Download the latest issue of the NoCOUG Journal. Lothar Flatz talks about the biggest issue in SQL tuning: the “salted banana.” We predict that the phrase “salted banana” will become as widely known in the Oracle community as “compulsive tuning disorder.”Janis Griffin—a.k.a. the Looney Tuner—explains why the Oracle Database 12c “adaptive optimizer” is the best thing since sliced bread. The Oracle Database 12c query optimizer makes all previous versions of the query optimizer—and the query optimizers of Oracle competitors—seem primitive and foolish in comparison. All previous versions of the query optimizer stick to the plan, even when it is painfully, painfully obvious—after a few records have been retrieved—that the plan is terribly, terribly wrong. But why stick to a full table scan or an index scan if it becomes painfully, painfully obvious—after a few records have been retrieved—that there has been a terrible, terrible miscalculation and that the current plan is terribly, terribly wrong and should be abandoned, even though query execution has already started. If you were looking for a reason to upgrade to Oracle Database 12c, the adaptive optimizer is it.Guy Harrison talks up the five biggest trends in database technology. If you read his article, you will be able to respond intelligently when your CIO or enterprise architect asks you for your opinion.Iggy Fernandez explains why he doesn’t have a huge problem with the NoSQL fad. According to him, the NoSQL architecture is entirely compatible with the relational model and he points out that RDBMS vendors have already started incorporating these features into their products.Kyle Hailey provides a detailed explanation of the hottest topic in IT: thin provisioning of the entire tech stack—database as well as application. Business is dependent upon IT to deliver required applications and services but these applications and services are dependent upon timely, high-quality refreshes. Using thin provisioning, IT can deliver results faster, quicker, and cheaper.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 13 2015 - 02:06:15 CET