4 Replies Latest reply: May 21, 2008 4:01 PM by Ramesh Eega RSS

    Query taking time

      I have a select query

      select col1,col2,col3 from table1 order by col1,col3
      This table contains 4.5 million records initially and select was returing records under 2 min .This query was running for last one year with out any issues .
      But from last week onwards this qiery is taking more than 15 min to complete .No change in database and other components .
      How can i find out the root cause of this issue ? Any specific area i need to check ?