|
You are here |
www.dbaglobe.com | ||
| | | | |
leonotes.wordpress.com
|
|
| | | | | transitive closure?Wiki?Oracle?... | |
| | | | |
www.xt-r.com
|
|
| | | | | ||
| | | | |
iusoltsev.wordpress.com
|
|
| | | | | 465 ?! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%?%' OR A.LASTNAME LIKE '%?%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ?, ? ? A.COMPANY_ID = 1 ? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT... | |
| | | | |
tanelpoder.com
|
|
| | | Reading the following article about PARALLEL hint by Jonathan Lewis made me remember a somewhat related gotcha with parallelism. Often when creating (or rebuilding) an index on a large table, doing it with PARALLEL x option makes it go faster - usually in case when your IO subsystem is not the bottleneck and you have enough spare CPU capacity to throw in. A small example below: Tanel@Sol01> create table t1 as select * from all_objects; Table created. Tanel@Sol01> create index i1 on t1(object_id); Index created. Tanel@Sol01> exec dbms_stats.gather_table_stats(user, 'T1', cascade=>true, no_invalidate=>false); PL/SQL procedure successfully completed. Ok, for whatever reason I need to rebuild my index, and for speed I do it in parallel: - Linux, Oracle, SQL perf... | ||