1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

SQL Query Tuning Method in 10g

Discussion in 'SQL PL/SQL' started by gulzar, Aug 30, 2009.

  1. gulzar

    gulzar Guest


    I have written a view which is supposed to have more than 10 million of records ,but hardly got luck to see all the data , its taking much time to display all the data (select * from view) infact more than 1 hour. I have tried Hints but it seems to be of little use. Is there any alternative way to to tune the query of the views.Any way to use COLLECTION in this sort of situation.

    Thanks in advance.
  2. tyro

    tyro Forum Genius

    Likes Received:
    Trophy Points:
    Question> If your view has more than 10 million records, why do you want to display all the records together? Surely you can use a where clause in your query!