In Defense of Full-Table Scans by Jeff Maresh

Often times in life, we make decisions based upon the Law of Primacy. This law implies that what you learned first is what you recall first. This occurs even after new concepts appear that contradict what was originally learned. The saying old habits die hard is the popular version of this law. For DBAs and developers, we often see the Law of Primacy in action when it comes to full-table scans. If you've been around Oracle for any period of time, you are well familiar with the concept that full-table scans are bad and that they must be eliminated to improve database performance. Even though significant incremental improvements have sneaked into the Oracle server over successive versions that improve the utility and performance of full-table scans, this thought prevails.

 

When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. Sorry it's so complicated!

 

When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.

  • Author:: Jeff Maresh
In Defense of Full-Table Scans by Jeff Maresh
  • Item #: Paper0002
  * Marked fields are required.
Qty*
Price $0.00
Availability In-Stock