______SQL & Index Question
From: Emre Akbag <akbag_at_scr.siemens.com>
Date: Thu, 14 Sep 2000 10:55:46 -0400
Message-ID: <ZB5w5.1149$l35.16541_at_iad-read.news.verio.net>
Date: Thu, 14 Sep 2000 10:55:46 -0400
Message-ID: <ZB5w5.1149$l35.16541_at_iad-read.news.verio.net>
Hi,
[Quoted] [Quoted] 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:
[Quoted] 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:
- local index on (B,C) [Quoted]
- local index on (C,B) (What's the difference between 1 and 2 ?)
- global index on B
- local index on C
- none of them, but...
I'd appreciate any ideas.
-- Thanks in advance Emre AKBAG akbag_at_scr.siemens.com Siemens Corporate ResearchReceived on Thu Sep 14 2000 - 16:55:46 CEST