Friday, April 14, 2006

Mr. Jonathan Lewis's article "When 2+2=5"

"From web page of Jonathan Lewis comes his debunking of the myth (Urban legend?) that using the predicate of 1=2 causes a full table scan. On the page When 2 +2=5 Mr. Lewis goes through in detail his tests to prove this myth wrong. This is simply a continuation of his tests on versions 7 through 10xe of oracle to validate or invalidate his conclusions as Mr. Lewis does state this is the same on many versions of oracle but doesn’t provide proof. I did this because a colleague of mine disagreed with Mr. Lewis’s findings and just “knew” that Mr. Lewis was wrong and I had some time at home to kill. I will not draw any conclusions, or make any statements. I have simply provided the complete result sets and let you come to your own conclusions. All of these tests were done in production databases that were busy doing other work at the time, I thought this an appropriate environment instead of a sterile environment. I have provided the output from V$VERSION in every log. The entire output is here I moved the post to a file on my googlepages site as the post was massive and difficult to read. Draw your own conclusions based on the information supplied above.


Herod T said...

Now for my comment.

Mr. Lewis is correct.

Craig said...

Proves Jonathan right.

for some reason this particular issue has cropped up all over the net.

Must be one or two people posting the question around got the whole "world" excited.

jinpeng said...

Place one matted light pandora Jewelry left of the area for jewellery, and one to the right. pandora sale Place reflector light near where the camera is. Whatever you do, avoid mixing light types. pandora charms Use only non-fluorescent lights, and isolate your photo 'lab' away from natural light. pandora bracelets To have freedom with many settings that will be a must, we will have to use longer exposures. For longer exposures to pandora bracelet achieve maximum sharpness, we'll need a tripod. pandora bracelets sale Our hand shakes too much, when camera runs at exposition Buy a 'tripod' for You don't need a heavy duty tripod. pandora bangles If your setup will be on a desk, you can chose mini tripod - approx and stand tripod on the pandora necklaces desk as well, or longer tripod, approxand stand it on the floor. pandora beads Two desk lamps with soft light irrelevant if you are using photo tent -- the tent is there to soften the light and reflector light at the front. pandora earrings I keep the cube open at the front, for easier adjustments and photographs, unless jewellery is highly reflective of the image of me taking photograph. Uniform background colour is recommended. White background works great.