insert /*+ append */ into tab2 select * from tab2 ???

hung_my
hung_my used Ask the Experts™
on
what is this mean?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Allow the row to be loaded using DIRECT PATH (by-passing the SGA). Works since
Oracle 8 I think. You use this when you want to load large amounts of data fast.
You are entering the data from tab2 table into the same table. Since you have added the /*+ append */ hint the data is going to be loaded into the the table above the high water mark.

The high water mark is the limit within which oracle searches for free blocks in which data can be entered. If no such block is found then Oracle will add the data above the mark. In this situation the search of free blocks is avoided and therefore the insert is faster. However it is just one of the many tuning tips. The performance may or may not improve if you just use this command. The drawback is that your table will keep growing even if there is sufficient free space within it.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Commented:
It means add the data to table tab2 without creating any redo-logs , thus the insertion of data is faster as the step involved in creating the redo logs doesnt come into picture.

Author

Commented:
I want to know what is the + means here?
and what is the  /*...*/ means??

how they can be used in select statement? please give example for update /delete/modify :)
/*..... */  is used for commenting....
/*+......*/ is used for providing hints to oracle on how to execute the commands....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial