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