Re: OPTIMIZER_INDEX_COST_ADJ, Conceptual Idea

From: Don Burleson <don_at_burleson.cc>
Date: 20 Jan 2003 16:11:32 -0800
Message-ID: <998d28f7.0301201611.792c4759@posting.google.com>

OK, but why then do almost all Oracle systems show multi-block
(scattered) reads having average waits that are 10x longer than index
(sequential) reads?

Anyone have an insight?

Any link to this hotsos discussion? Received on Mon Jan 20 2003 - 18:11:32 CST

This message: [ Message body ]
Next message: Bass Chorng: "Does it read empty blocks into buffer cache ?"
Previous message: DA Morgan: "Re: Oracle performance tuning question"
In reply to: Telemachus: "Re: OPTIMIZER_INDEX_COST_ADJ, Conceptual Idea"
Next in thread: Jonathan Lewis: "Re: OPTIMIZER_INDEX_COST_ADJ, Conceptual Idea"
Reply: Jonathan Lewis: "Re: OPTIMIZER_INDEX_COST_ADJ, Conceptual Idea"
Reply: Noons: "Re: OPTIMIZER_INDEX_COST_ADJ, Conceptual Idea"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US