| Precompiled sql [message #446263] |
Sun, 07 March 2010 04:52  |
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
|
Senior Member |
|
|
Hi,
Quote:View is a precompiled sql query.
What do you mean by the word precompiled?
Are views useful or beneficial for performanace,
I read many documents on internet, but i found them conflicting so i raised this question in this forum.
Regards,
Ritesh
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Precompiled sql [message #446271 is a reply to message #446269] |
Sun, 07 March 2010 06:23  |
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
|
Senior Member |
|
|
|
Hi Michel,
But i want to know is there anything in Oracle which is precompiled.
If yes what are they?
Precompiler is something which converts statements not in host programming language to statement in host language, am i right?
If not please explain
Regards,
Ritesh
|
|
|
|
| Re: Precompiled sql [message #446272 is a reply to message #446271] |
Sun, 07 March 2010 06:46 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Stored procedure, function, package, java, type, trigger.
In this case precompiled means stored in a compiled form before (pre) loading and execution: they are are not stored in source form and compiled on the fly (contrary to views).
That said, views are "precompiled" in the sens that they are VALID only if the "compilation" has validated its syntax and semantic but there is no "precompiled" form of a view/query.
Regards
Michel
[Updated on: Sun, 07 March 2010 06:51] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
