The DB2Night Show #133: Why Low Cardinality Indexes (STINK), Ember Crooks


Posted by Scott on April 18, 2014, 2:42 pm
in DB2 LUW ( The DB2Night Show)







title="Ember Crooks on LinkedIn">
Ember Crooks, Rosetta


Special Guest: Ember Crooks, Rosetta



Why Low Cardinality Indexes Negatively Impact Performance



100% of our studio audience learned something! Based on her popular IBM Developer Works article and blogs, IBM DB2 GOLD Consultant title="Ember Crooks on LinkedIn">Ember Crooks brings her articles on Index Cardinality to life via her excellent IDUG presentation! Watch our replay for details...








title="Ember Crooks on LinkedIn">
Ember Crooks, Rosetta


Special Guest: Ember Crooks, Rosetta



Why Low Cardinality Indexes Negatively Impact Performance



100% of our studio audience learned something! Based on her popular IBM Developer Works article and blogs, IBM DB2 GOLD Consultant title="Ember Crooks on LinkedIn">Ember Crooks brings her articles on Index Cardinality to life via her excellent IDUG presentation! Watch our replay for details...






Show Host Scott Hayes Commentary



When I first met Ember several years ago at an IDUG conference, she was so shy she was practically hiding under her chair so that no one would talk to her. Now she's an excellent blogger at DB2Commerce.com, a published author on IBM Developer Works, a multi-year speaker at IDUG, an IBM Information Management Champion and DB2 GOLD Consultant, a DB2's GOT TALENT 2013 3rd place winner, a regular guest on The DB2Night Show™, and, in general, a leading advocate for the DB2 community! What a change! I'm proud of you! On behalf of the DB2 Community, thank you very much for bringing your DB2 real-life lessons learned to public forums so that we can all benefit from your trail-blazing experiences! Follow Ember on Twitter at @ember_crooks.


IMPORTANT NEWS: IDUG DISCOUNT CODE!


DBI Software and The DB2Night Show are proud to announce a special discount code that you can use to get 10% off your IDUG NA Phoenix registration: DB2GotTalent14. This code saves you $200 and matches the price for organizations sending three or more people! Any questions? icon_biggrin


Congratulations!



Subhash Karale at ACI in Bangkok Thailand completed our survey after Episode #132 "All About IDUG and DB2's GOT TALENT Winners" and has won a $25 Amazon.com gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!


Bangkok! Yes, now you know why we say "Good morning, good afternoon, and good evening wherever you are in the world!" at the start of each show! DB2 professionals are tuning in from all over the world!






A message from our sponsor:

DBI Software









Magic Hat Money

Working with DBI is like making money magically appear!


Typical customers enjoy 30-60% CPU utilization reductions in the first week, plus measurably faster
transaction and query response times. More importantly, your time savings will be substantial!
Read our newest title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">due diligence,
and speak with as many references as you have time to call.


We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior
DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce
performance on Black Friday multiple years in a row. 7 of the Top 25 Retailers, plus others, plus top Banks,
State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI




Turn a Penny into a Dime with DBI at IDUG











The title="IDUG North America May 12-16, Save $200 off registration with Discount Code: DB2GotTalent14">
2014 IDUG DB2 Tech Conference in Phoenix, Arizona
is the premier training event dedicated exclusively to
IBM’s industry-leading DB2 product family. The event includes a robust technical schedule, in-depth seminars,
networking opportunities and a vendor exhibition featuring the latest DB2 products.
And, don't miss
the DB2 LUW Top Gun Education Seminar
taught by href="http://ca.linkedin.com/pub/martin-hubel/0/181/697" target="NEW">Martin Hubel
and Scott Hayes!
Visit DBI Software in Booth #105, Experience the Magic of DBI, Get 10X title="Get 10X ROI with DBI, Guaranteed! Learn More!">ROI, and you could win a
title="See the Beats Pill Portable Speaker on Amazon.com">Beats Pill Portable Speaker! Enjoy magic tricks
performed by professional magician Frank Velasco!

target="NEW"
title="IDUG North America May 12-16, Save $200 off registration with Discount Code: DB2GotTalent14"> alt="IDUG North America May 12-16, Save $200 off registration with Discount Code: DB2GotTalent14" border="3">


Save $200 with Discount Code: DB2GotTalent14






Join The DB2Night Show™ LinkedIn Group


The DB2Night Show™ has a LinkedIn Group. The
"closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including
future shows and replay information, and, if you like, start some discussions about the show! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!




Get the Download Replays



WMV Format - approximately 74MB


To download a recorded replay of Episode #133 in WMV format, right click on
the link below and choose "Save As..."


Episode #133, 18 April 2014,
Why Low Cardinality Indexes Negatively Impact Performance!



MP4 Format - standard resolution - 132MB



Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!




Did you learn something from this show?


See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin


Share a great show with your friends and followers:















Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=504