Tuning to enforce parallelism

 Hello All,

I have 2 queries which are used for generating reports. Both the queries are on two huge facts, joined to  6- 7 small dimensions. Both the fact tables are partitioned and each partition has around 10 million records.

The query is accessing data of one day, which is a relatively small number - 912 records.

The 1st query doesnot use parallelism, hence it takes forever to return any records.

The 2nd query uses parallelism and returns records in seconds.

Apart from specifying the parallel hint, is there any other way in which we can make a query to run in parallel?? (Even specifying the parallel hint doesnot work!)