1. amitsvyadav New Member

   Hi,
   I have a table in which there are 100 million rows and 2 supporting table, also have same amount of records.
   Now, I have created a view to get all related information but it is taking 50-60 mins to querying the data from the view.
   please advice waht to do so that i can get data in quickly from my view.
   Thanks,
   Amit
   

   amitsvyadav, Nov 7, 2008

   #2
2. FrankKalis Moderator

   Please post the code and the structure of the underlying tables. I would guess that you're missing a where clause and probably some indices.
   

   FrankKalis, Nov 7, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in