Home » SQL & PL/SQL » SQL & PL/SQL » Precompiled sql (Oracle, 10g, Windows server 2003)
Precompiled sql [message #446263] Sun, 07 March 2010 04:52 Go to next message
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 #446264 is a reply to message #446263] Sun, 07 March 2010 05:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ View is NOT a precompiled query, this is meaningless.

2/ No.

3/ Do not trust all what you read on Internet; post here the links and we can tell you.
Of course, the primary source is Oracle documentation

Regards
Michel
Re: Precompiled sql [message #446265 is a reply to message #446264] Sun, 07 March 2010 05:40 Go to previous messageGo to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Thanks Michel

Regards,
Ritesh
Re: Precompiled sql [message #446268 is a reply to message #446265] Sun, 07 March 2010 06:11 Go to previous messageGo to next message
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Hi Michel,
This site (orafaq.com) itself says that View is a precompiled sql query.

Check this link


http://www.orafaq.com/wiki/View


Regards,
Ritesh

[Updated on: Sun, 07 March 2010 06:11]

Report message to a moderator

Re: Precompiled sql [message #446269 is a reply to message #446268] Sun, 07 March 2010 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks, this is fixed.

Regards
Michel
Re: Precompiled sql [message #446271 is a reply to message #446269] Sun, 07 March 2010 06:23 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Precompiled sql [message #446438 is a reply to message #446272] Mon, 08 March 2010 06:12 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Snapshots, or Materialized Views are 'pre-executed views'
Previous Topic: Convertion of Julian Date into dd/mm/yyyy
Next Topic: not able to get single mvlog
Goto Forum:
  


Current Time: Thu Dec 08 01:53:52 CST 2016

Total time taken to generate the page: 0.17096 seconds