______SQL & Index Question

Article View: comp.databases.oracle.misc

Article #107

Back to comp.databases.oracle.misc Previous Next

#107

From: Emre Akbag
Date: Thu, 14 Sep 2000 00:00

31 lines
1593 bytes

Hi,

say I have a table with many columns and 100.000 rows.
Table is also partitioned in 10 pieces according to the values in Column C:

    Column B has 70.000 different values
    Column C has 10 different values.

I'll query the table always giving two arguments for B and C.

How should I index this table:

1) local index on (B,C)
2) local index on (C,B) (What's the difference between 1 and 2 ?)
3) global index on B
4) local index on C
5) none of them, but...

I'd appreciate any ideas.





--
Thanks in advance

Emre AKBAG

akbag@scr.siemens.com
Siemens Corporate Research

Technical Details

Message-ID: <ZB5w5.1149$l35.16541@iad-read.news.verio.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,f21e719eb8eb6bf4,start
X-Google-Attributes: gidfb53f,public
X-Google-Thread: f99a8,f21e719eb8eb6bf4,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: fa4f9,f21e719eb8eb6bf4,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f5464,f21e719eb8eb6bf4,start
X-Google-Attributes: gidf5464,public
From: "Emre Akbag" <akbag@scr.siemens.com>
Subject: ______SQL & Index Question
Date: 2000/09/14
Message-ID: <ZB5w5.1149$l35.16541@iad-read.news.verio.net>
X-Deja-AN: 669650282
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@verio.net
X-Trace: iad-read.news.verio.net 968943097 129.73.10.199 (Thu, 14 Sep 2000 14:51:37 GMT)
Organization: Verio
X-MSMail-Priority: Normal
NNTP-Posting-Date: Thu, 14 Sep 2000 14:51:37 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools,hannover.uni.comp.oracle,comp.databases.oracle.server