CREATE TABLE my_table
(col_1  DATE
,col_2  NUMBER -- FOREIGN KEY
,col_3  NUMBER
,target VARCHAR2(1024)
);

SELECT something
FROM   other_table
WHERE  other_table.target IN
(
   SELECT target
   FROM   my_table
   WHERE  col_1 = to_date('2009-01-13','YYYY-MM-DD')
   AND    col_2 = :variable_1
   AND    col_3 > :variable_2
)

SQL> CREATE TABLE sptest (
  2      a number
  3  ,   b number
  4  ,   c number
  5  )
  6  PARTITION BY RANGE (a)
  7  SUBPARTITION BY LIST (b)
  8  SUBPARTITION TEMPLATE (
  9      SUBPARTITION S1 VALUES (1)
 10  ,   SUBPARTITION S2 VALUES (2)
 11  ,   SUBPARTITION DF VALUES (DEFAULT)
 12  )
 13  (
 14          PARTITION VALUES LESS THAN (1)
 15  ,       PARTITION VALUES LESS THAN (2)
 16  )
 17  /

Table created.

SQL>
SQL> ALTER TABLE sptest
  2  ADD PARTITION VALUES LESS THAN (3)
  3  /

Table altered.

CREATE TABLE a_lot_of_data (EventDate DATE, CompanyID INTEGER, more_columns SOMETHING) PARTITION BY RANGE (EventDate);

CREATE BITMAP INDEX a_lot_of_data_date ON a_lot_of_data(EventDate);
CREATE BITMAP INDEX a_lot_of_data_company ON a_lot_of_data(companyid);

SELECT /*+ hint INDEX_COMBINE(a_lot_of_data a_lot_of_data_date a_lot_of_data_company) */ more_columns FROM a_lot_of_data WHERE EventDate BETWEEN :1 AND :2 AND CompanyID=:3