Link to home
Start Free TrialLog in
Avatar of hung_my
hung_my

asked on

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

what is this mean?
Avatar of rogaut1
rogaut1

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.
ASKER CERTIFIED SOLUTION
Avatar of anand_2000v
anand_2000v
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of hung_my

ASKER

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....