If you query multiple tables, you can specify multiple SELECT PARALLEL hints and multiple PARALLEL attributes.Įxample 8-8 shows the addition of the new employees who were hired after the acquisition of ACME. In that case, existing INSERT SELECT statements that have the select operation parallelized can also have their insert operation parallelized. The ability to parallelize insert operations causes a change in existing behavior if the user has explicitly enabled the session for parallel DML and if the table in question has a PARALLEL attribute set in the data dictionary entry. If one operation cannot be performed in parallel, it has no effect on whether the other operation can be performed in parallel. Thus, parallelism of the INSERT and SELECT operations are independent of each other. The PARALLEL hint after the INSERT keyword applies to the INSERT operation only, and the PARALLEL hint after the SELECT keyword applies to the SELECT operation only. To remove Parallels Tools from a Windows virtual machine: Start the virtual machine, and log in to the guest OS. SELECT statement, you can specify a PARALLEL hint after the INSERT keyword, in addition to the hint after the SELECT keyword.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |