Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		www.dbaglobe.com Donghua's Blog - DBAGlobe: Using "nonunique index to enforce uniqueness" is a good way?
\|	\|	leonotes.wordpress.com (transitive closure)?(Constraint-Generated Predicates) \| LEO Notes	1.8 parsecs away Travel
\|	\|	transitive closure?Wiki?Oracle?...	1.8 parsecs away Travel
\|	\|	www.xt-r.com XT&R blackboard: ? distinct values ?, ? TopN	1.3 parsecs away Travel
\|	\|		1.3 parsecs away Travel
\|	\|	iusoltsev.wordpress.com FIRST_ROWS CURSOR_SHARING_EXACT \| Oracle mechanics	1.1 parsecs away Travel
\|	\|	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...	1.1 parsecs away Travel
\|	\|	tanelpoder.com A gotcha with parallel index builds, parallel degree and query plans \| Tanel Poder Blog	7.5 parsecs away Travel
\|		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...	7.5 parsecs away Travel