|
The Cost of Poor Database Design |
|
MikeA
|
Wednesday, May 30, 2007 9:32 AM
|
|
|
|
I’ve been searching for a definitive answer to the question: “What is the cost of poor database design?” No doubt you have all seen the cost/benefit graphs for fixing application problems and the pyramid showing how up to 90 percent of performance issues in a running database are SQL and ind ...
|
 |
|
|
Read More...
|
|
|
|
Feuerstein in Buenos Aires and Magic Tricks |
|
StevenFeuersteinTW
|
Wednesday, May 09, 2007 11:24 AM
|
|
|
|
It is Wednesday, May 09, 2007 and I am sitting in the Admiral's Club at the Buenos Aires airport. I just finished two days in this lovely city. My first day was spent enjoying the chilly, but very sunny afternoon, walking for four hours around the city. It is a busy, busy place with many buses throwing way too much gritty exhaust into the air (hey, ...
|
|
|
|
Comments (3)
|
Read More...
|
|
|
Using Cross-Instance Parallel Query |
|
MikeA
|
Friday, May 04, 2007 11:23 AM
|
|
|
|
With the use of RAC on the rise it is time to talk about the use of a feature very under-utilized in Oracle. This feature I refer to is cross-instance parallel query. Many times on site visits I see people using single-instance parallel query, but no one whose system I reviewed has used cross-instance parallel. Some weren’t aware it was available ...
|
|
|
|
|
Read More...
|
|
|
From SQL Optimization Hints to Plan Instructions |
|
RichardTo
|
Wednesday, May 02, 2007 7:05 AM
|
|
|
|
Most database vendors provide optimization hints which enable a user to influence the decision the database SQL optimizer will make when determining which execution plan it will choose. Oracle provides a full set of optimization hints to help users to rectify an i ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Greetings from Las Vegas! |
|
StevenFeuersteinTW
|
Thursday, April 19, 2007 9:16 AM
|
|
|
|
I am visiting this, well, very artificial paradise dropped into the middle of a desert, so as to participate in Collaborate 07. It's been an interesting and fun several days. I have a room on the 26th floor of the Mandalay
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Sizing of Oracle10g Indexes |
|
MikeA
|
Wednesday, April 04, 2007 9:15 AM
|
|
|
|
In my last blog entry we looked at sizing tables in 10g, of course the other side of that coin is the sizing of indexes. As with tables the Oracle8 manuals had an explanation of how to size indexes, but manuals since then have been strangely silent on the subject. In this blog I will address the sizing of normal, b-tree ...
|
|
|
|
|
Read More...
|
|
|