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

Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.

Re: Very long "WHERE" list.

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 11 Jul 2004 23:01:22 -0700
Message-ID: <73e20c6c.0407112104.69284845@posting.google.com> 





ctcgag_at_hotmail.com wrote in message news:<20040711181723.816$1W_at_newsreader.com>...


> 

> Why must it?  On my machine, that is over 250,000 clock ticks per row.

> That should be more than enough time to do a co-local lookup into a index

> and lookup into a table with a good cluster factor on the indexed column.




just exactly how many people are replying to the question?
Received on Mon Jul 12 2004 - 01:01:22 CDT












Original text of this message













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