Close

Db2 Indexes and the Optimizer

(IN)

Stream: DB2
Time: 10:15 - 11:15


Presentation

Db2 indexes plays a major role when processing SELECT statements and the optimizer might choose the wrong one. In this session, the audience will revise index structure, will learn how to define the best index for a single table query, the worst predicates and how to trick the optimizer in the predicates without using hint.

Attachments

There is currently no attachment for Db2 Indexes and the Optimizer

Speakers


  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

  • Rodolfo Custodio at Broadcom Mainframe Software
  • Currently working as a Senior Software Engineer for Db2 Utilities at Broadcom (formerly CA). Rodolfo has 15+ years’ experience as a mainframe professional, 10+ of them with DB2,worked as system programmer, DBA and consultant supporting DB2, IMS, QREP, and IDAA for IBM Brazilian customers and later moved to IBM Czech Republic as DB2 and IMS system programmer. With all these years working with DB2 and IMS, acquired great background in maintenance, migration, installation, performance analysis and tuning, dump analysis, problem determination and deep Z systems skills. He also has a wide industry knowledge in banking, retail, government and manufacturing. He holds the professional certification: Master Certified Technical Specialist, Data Management from The Open Group.


    Email: rodolfo.custodio@broadcom.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!