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 -> Partitioning or BitMap-Index?

Partitioning or BitMap-Index?

From: Christian Hartmann <cha_at_christian-hartmann.de>
Date: 12 Feb 2003 04:17:53 -0800
Message-ID: <7c275508.0302120417.53d37f62@posting.google.com> 





Hi there,



I have 8.1.7 database and a table with a column with values of 0 and
1.



The column is used in every sql-statement against the table.



For this low cardinality I wonder wheter a bitmap-index or a
partitioning is the best way to improve the performance of this table.



Any suggestion? 



Regards,



Christian Hartmann
Received on Wed Feb 12 2003 - 06:17:53 CST












Original text of this message













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