regarding some topics in oracel [message #418540] |
Mon, 17 August 2009 03:32  |
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   |
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
|
|
|
|