| Does The Query get Fired Again [message #277049] |
Sun, 28 October 2007 04:07  |
|
|
Does the query get fired again when i query a existing view
1. create view abc as select name from Table
2. select name from abc
Table is a really large table wid many columns and many rows
Lookin for a better performance coz i need names in one procedure and again need the same names for deletion in another procedure
I dont want to fire the same query twice dats y.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Does The Query get Fired Again [message #277265 is a reply to message #277077] |
Mon, 29 October 2007 06:12  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If you want to execute a query once, and have a queriable set of data as a result, you need to look at Materialized Views
If your query is as simple as the one you posted, then you should be able to create a MV that will reflect changes to your data in real time (look up the phrases 'FAST REFRESH' and 'ON COMMIT' in the MV documentation), otherwise you will need to schedule refreshes to the data.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
