storing the resutls of a view

[mikedaruke]

I need to run a big SQL statement that looks at a table and returns about 50k rows with 5 columns. The statment runs against tables that are like 7 million rows deep. It takes about 1 hour.

My questions is I created a view, which I am not sure gets me what I want. I want to be able to run the statment at night, then the results stay in a table. This way every night I will update the table, and during the day I am going to have a website that does queries off the table, which is the results of the view. I need this to be fast so i need the results of the view to be there without having to wait 1 hour each time.

Any way to do this?

 

[jaxtell]

I think what you want is a Materialized View.

 

[Beilstwh]

I am really surprised that a small table like 7 million rows would take an hour to query against. But jaxtell is correct, use a materialized view, this is exactly what it is designed for.

Bill
Oracle DBA/Developer
New York State, USA