Browse by Tags

• 64-bit
• cost based optimizer
• Storage

• Brains still matter - silly SSD notions

  Everytime a good product comes out, people seem to contrive bad ideas for what can be replaced, usually brains, or people with brains, or that people lacking brains can accomplish something on their own. Let me put it simply. Suppose one had a query that Read More... Posted Monday, September 08, 2008 4:32 PM by jchang | 8 Comments Filed under: Performance, Storage, internals

• IO Cost Structure – Anticipating SSD arrays

  An observant person has probably noticed that SQL queries requiring disk reads not only have longer duration but also higher CPU times. It is not hard then to deduce that disk access (for both HDD and SSD), which involves the OS performing an IO call, Read More... Posted Thursday, September 04, 2008 2:23 PM by jchang | 16 Comments Filed under: Performance, Storage, internals, cost based optimizer

• About 64-bit

  Back in the 1997 time frame, I gave a presentation projecting out when 64-bit operating systems and applications should become pervasive in the high volume platforms. My best estimate was this would be some time in 2003 or 2004. This meant that hardware Read More... Posted Friday, March 28, 2008 4:16 PM by jchang | 13 Comments Filed under: Performance, 64-bit, internals