-
direct-path insert
Hi,
What is the right syntax/hint for direct path insert?
I tried all these...and they all worked.
1. insert /*+ append */
2. insert /* + append */
3. insert /**+append **/
4. insert /**++apend **/
There seems no error for coding the hint
How do i know if my direct path insert really is direct?
Thanks
-
the first one - check how much redo you are generating to see if it is working for you
-
or you could do ...
Code:
insert --+ append
into ...
... I believe, but I prefer the /*+ append */ notation myself.
Yes, no error is raised if a hint is malformed, even such as ...
Code:
insert /*+ apend */ into
... the hint is just treated as a comment.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|