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

    1019123

      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