1 Resources for

clustering_factor

Sponsored White Papers, Webcasts, and Downloads

Optimize SQL query speed with the Oracle clustering_factor attribute: The cost-based optimizer CBO improves with each new release of Oracle, and the most current enhancement with Oracle9i is the consideration of external influences (CPU cost and I/O cost) when formulating an execution plan. As Oracle evolves into Oracle10g we may see even more improvements in the ability of the...; Tags: Databases, Donald Burleson, cost based optimizer, column value, clustering_factor, Oracle Corp., selectivity; Technical articles 2003-10-27

Database Optimization: Measuring Oracle disk I/O speed: Because all Oracle databases retrieve and store data, the relative cost of physical disk access is an important topic. In Oracle, we see two types of data block access:db file sequential read—A single-block read (i.e., index fetch by ROWID)db file scattered read—A multiblock read (a full-table scan, OPQ, sorting)Physical disk...; Tags: disk speed, Oracle Corp., Donald Burleson, disk, I/O, full-table scan, database; Technical articles 2004-03-01
Optimize an Oracle network configuration: Oracle databases are often shared across geographical areas, so it's imperative that the Oracle professional understand how database performance is affected by network communications. The Transparent Network Substrate TNS, provided by Oracle, allows distributed communications between databases.The TNS serves as an insulator between Oracle’s logical data request and the physical...; Tags: NETWORKING, Databases, Transparent Network Substrate, network configuration, Donald Burleson, Oracle Corp., Oracle Net, network; Technical articles 2003-11-18

Harness the Full Power of Internet Explorer: This pre-packaged presentation contains everything you need to instruct end users about how to the most out of the Internet and Internet Explorer--eve ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now