10 Replies Latest reply on Jun 16, 2016 6:46 AM by Paul Horth

    Require hint for group by and where clauses in same fact table


      Hi friends,


      I am using group by in one fact table and 3 where clause and one IN condition in which i am writing one query to fetch data from other dimension table.


      Which hint will help me to fetch the records at lowest time any idea friends ?


      I am using Oracle 11g