Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Three billion logical reads?

Three billion logical reads?

From: David Aldridge <david_at_david-aldridge.com>
Date: Fri, 26 Oct 2007 04:45:14 -0700 (PDT)
Message-ID: <423318.30443.qm@web814.biz.mail.mud.yahoo.com>


Part 1: If I have a table of 80 million records and I outer join that to twelve other tables, and the tables are accessed with nested loop outer joins against non-unique indexes having a blevel of 3, and if there is only a 50% (say) chance of there being a matching record in those tables, then is the number of logical reads to perform the join equal to something in the order of:    

  80,000,000*12*(3+.5)    

  ?    

  In other words, around 3.3 billion logical reads? Or do I need more coffee this morning?    

  Part 2: What would you say is a reasonable ballpark time for a logical read, on a decently equipped server with SAN storage? Millisecond? Less?            

  Background: I'm stuck in version 9 with large tabes outer-joined to many smaller tables -- no inut join swapping and hence no (reasonably efficient) hash outer joins.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 26 2007 - 06:45:14 CDT

Original text of this message

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