gpt4 book ai didi

sql - 什么是并行表创建?

转载 作者:行者123 更新时间:2023-12-02 08:56:33 26 4
gpt4 key购买 nike

我在oracle中看到了一个名为“并行化表创建”的概念,但我不明白其目的是什么,是将现有表复制到新表吗?

最佳答案

这不仅仅是创建表格......

Quote :

If you parallelize the creation of a table, that table then has a parallel declaration (the PARALLEL clause) associated with it. Any subsequent DML or queries on the table, for which parallelization is possible, will attempt to use parallel execution.

并行执行如何工作

Quote :

Oracle divides the task of executing a SQL statement into multiple smaller units, each of which is executed by a separate process. When parallel execution is used, the user's shadow process takes on the role of the parallel coordinator. The parallel coordinator is also referred to as parallel execution coordinator or query coordinator.

关于sql - 什么是并行表创建?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/4415174/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com