jung1975
asked on
Query question
I have a query like below..
Insert /*+ append */ into sales select * from temp_sales.
What is /*+ Append */ ? when do you use it? is it some kind of index hint?
Insert /*+ append */ into sales select * from temp_sales.
What is /*+ Append */ ? when do you use it? is it some kind of index hint?
/*+ APPEND */ is an oracle hint, that tells oracle to add the data above the high water mark, and does not try to find empty space in the already used blocks of the table.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.