Indexing Help

From: Anon <cxy2002um_at_yahoo.com>
Date: 18 Dec 2003 14:38:12 -0800
Message-ID: <521a1a8f.0312181438.19f6d6b6@posting.google.com>

I have a table with 2 million rows.

I am doing the following select statement against this table.

SELECT *

               FROM TableA
              WHERE A_ID = '1235586'
                AND DATE_COL1 BETWEEN to_date('01-01-2004','DD-MM-YYYY')
                                        AND to_date('02-01-2004','DD-MM-YYYY')
                AND (   A_TYPE IN (3, 4, 5)
                     OR (A_TYPE = 16 AND A_STATUS = '0')
                    )
                AND B_TYPE IN (1, 2)
                AND B_STATUS IN (1, 2)
                AND SUBSTR (C_ID, 1, 2) NOT IN ('XI', 'XO', 'XD')

A_type column is low cardinality (3,4,5,9,2,11,16)
b_type column too (1,2,3)
a_status low also (1,0)

c_id is not, true id column
A_id same as C_id
dates_col1 ofcourse is are just date all over the place.

Any help would be greatly appreciated. Received on Thu Dec 18 2003 - 16:38:12 CST