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: How to optimize query's execution?

Re: How to optimize query's execution?

From: uf <uf_at_one.com>
Date: Wed, 31 Aug 2005 14:54:56 +0200
Message-ID: <df49b8$jv5$1@domitilla.aioe.org> 





> How many rows in j have currentstate='X'?




3390



> How many rows have state='postponed'?




3390



 How many rows have both simultaneously?



3390



> What fraction of the rows in k satisfy the in-list?




all of 3390



> What column(s) (and in what order) are included in the my_state_idx index?




MY_STATE_IDX ----> MY_JSTATE.INTERNAL_ID

MY_KEYS_IDX ------> MY_KEYS.INTERNAL_ID

Received on Wed Aug 31 2005 - 07:54:56 CDT












Original text of this message













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