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: Separate Index or Composite Indice ?

Re: Separate Index or Composite Indice ?

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 31 Aug 2007 11:01:08 GMT
Message-ID: <46d7f4f4$0$8221$79c14f64@nan-newsreader-05.noos.net>


On Thu, 30 Aug 2007 19:47:19 +0000, xhoster wrote:

> "userjohn" <userjohn_at_mailinator.com> wrote:

>> 10gR2
>>
>> If you have :
>> 2 columns on a hi-traffic transactional table - one ("some_id") high
>> cardinality
>> - and one ("yes_no") low cardinality
>>
>> You use both columns in SQL - "some_id" is used in JOIN and "yes_no" as
>> a predicate

>
> In the same SQL, or in separate SQLs?

Always in the same?

Always in separate?
You want to optimize all separate SQL?

You'll have to be more precise about your purpose. Received on Fri Aug 31 2007 - 06:01:08 CDT

Original text of this message

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