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

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.