Tech.Jobs.Biz.Success

Technology blog,Readers across the world. It contains articles on mainframe,cloud,Analytics,mobile.

Already a Member? Log In to Your Account
Technology blog,Readers across the world. It contains articles on mainframe,cloud,Analytics,mobile.
URL: http://srinimf.com
Added: January 26, 2011
Authority: 28.9743
Type: Website
Language: English
  Analytics :: more
   Latest Posts :: more

DB2 V11 – New Technique Duplicate Removal

Enhanced duplicate removal: – Lots of queries require duplicate removal: e.g. DISTINCT, GROUP BY, etc. – Dup elimination via sorting can be expensive – New techniques: Index duplicate removal, early out Index duplicate removal: One feature that

DB2- Joins Performance Tuning

Response time Response time is determined mostly by the number of rows participating in the join number of rows participating in the join Provide accurate join predicates Provide accurate join predicates ?? Never use a JOIN without a predicate Neve

Teradata – Active Load

Active Load Teradata is able to load data actively and in a non-disruptive manner and, at the same time, process other workloads.Teradata delivers Active Load through methods that support continuous data loading. These include streaming from a queue,



  Related Blogs
Language: English
Language: English
© 2006-2014 OnToplist.com, All Rights Reserved