SAP圈友天地 (S/4HANA & ECC)- Digital Transformation

摘要： Fabian -- Thanks for the question regarding "parallel select from remote site", version 10.2.0.3Submitted on 20-Jun-2011 12:57 Central time zoneTom's latest followup | Bookmark | BottomLast updated 19-Mar-2012 10:19You AskedHi Tom (and other readers) I'm searching for solution how 阅读全文

摘要： Question:I have an sql like this:Insert into ASelect * from B;Now I want it to run in parallel. My question is to parallelize the insert or select or both? See the following sqls, can you tell me which one is correct or which one has best performance. I don't have dba permission, so I cann't 阅读全文

摘要： Oracle SQL Hints/*+ hint *//*+ hint(argument) *//*+ hint(argument-1 argument-2) */All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.There should be no schema names in hints. Hints mus 阅读全文

摘要： 使用append提示进行insert叫做直接路径加载插入，使用这种提示因为系统不去查找freelist链表中的空闲块，直接在高水标记位以上插入数据，因此速度比较快。但是也应该注意直接路径加载插入有一些不同：1.它不记录日志，因此一旦插入的数据在没有保存回磁盘的时候发生掉电之类的状况插入的数据不能重做。2.它比较浪费磁盘空间，有心的同学可以做个简单的实验，创建个空表，用insert 插一些数据，然后delete掉，然后再用insert插一些数据，再delete掉，这样反复操作，最终用delete把表清空，然后用下面的语句查一下表的大小，可以看到一个空表占了可怕的磁盘空间！Select round 阅读全文