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 -> About indexes

About indexes

From: daniellopez21 <daniellopez21_at_gmail.com>
Date: 17 Oct 2005 00:33:31 -0700
Message-ID: <1129534411.110053.11490@g43g2000cwa.googlegroups.com> 





Hello,



I have a table with 3.000.000 rows. The column 'A', have 2 posssible
values: RE or FI.



The value RE is in 2.950.000 rows, and the value FI is in 50.000 rows.



i want execute : DELETE FROM my_table WHERE my_column = 'FI'.




żż I should create index in my_column ??? Bitmap index??




I'm sorry, but my english is disastrous.



Thanks ĦĦ
Received on Mon Oct 17 2005 - 02:33:31 CDT












Original text of this message













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