Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Figure illustrates the section the that shows this

Chapter 5 ■ troubleshooting Query transformations

Once we have all this base information about the table and its indexes (note we also have the clustering factor CLUF in this basic information), we can start to determine how to get the information the cheapest way. For example, the CBO will consider a single table access path and from that will consider a Tablescan (cost 3) or index (AllEqRange) (cost 2) and then tell us which was cheapest: Best:: AccessPath: IndexRange. Figure 5-10 illustrates the section in the 10053 that shows this.

Figure 5-11. The optimizer abandons a join because it’s greater than the best so far cost


In the next chapter we’ll cover SQL*Profiles and what to do when an emergency strikes and we need the right performance, fast!


How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI3E0D2C9
Uploaded by :
Page 1 Preview
figure illustrates the section the that shows this
Sell Your Old Documents & Earn Wallet Balance