Home » SQL & PL/SQL » SQL & PL/SQL » regarding some topics in oracel
regarding some topics in oracel [message #418540] Mon, 17 August 2009 03:32 Go to next message
karthikeyanc2003
Messages: 33
Registered: August 2009
Location: india
Member
Hi folks,
While i came to insert into the table i came to hear this topics from my team leader to use, let me know the information above the following topics

append parllel logging
append no logging
add hint to the query


Thanks in advance
Re: regarding some topics in oracel [message #418542 is a reply to message #418540] Mon, 17 August 2009 03:39 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Don't include NO LOGGING as a clause until you know what you're doing. Nothing will upset your DBAs more than finding out that you've created some data that they can't recover in the even of a crash.

Don't include HINTS until you know what you're doing - the CBO gets the answer right most of the time - much more often that you will do.

APPEND

Overview of Parallel execution

[Mod-Edit: Frank fixed tag-nesting so URL is displayed as hyperlink]

[Updated on: Mon, 17 August 2009 11:52] by Moderator

Report message to a moderator

Re: regarding some topics in oracel [message #418550 is a reply to message #418542] Mon, 17 August 2009 04:55 Go to previous message
Michel Cadot
Messages: 64118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To generalize do not do anything until you know what you're doing.

Regards
Michel
Previous Topic: Tablespace Option in Update and Insert Statement
Next Topic: Synonym - Which table it points to
Goto Forum:
  


Current Time: Tue Dec 06 04:53:56 CST 2016

Total time taken to generate the page: 0.08853 seconds