Toad World® Forums

Index advisory for SQL Optimizer for DB2

Hello gents,

Any one knows of the new version of SQL Optimizer for DB2 has the option for index advisory? Early in 2014 it was on beta version and it was suppose to be available on next release on Jan 2015.

This what i had at that time.

Get index recommendations with SQL Optimizer for DB2 z/OS

By Steve Hilker

Anyone knows about this?

Thanks.

Hi wmasad,

Thank you for your interest in the product. The lastest version 5.5.0 of SQL Optimizer for DB2 z/OS does include a feature to generate index alternatives for a single SQL statement. After entering or pasting your SQL statement in the editor, click on the :Generate Index" button to start the process. A list of index alternatives will be returned and then you can test run the alternatives to find the best.

Thanks,
Alex

Dear Alex

Thank you for your promote response.

Noted and well received.

Kind regards.

Waleed Masad

+965 50630966

From: Alex Luk [mailto:bounce-AlexLuk@toadworld.com]
Sent: Tuesday, May 2, 2017 2:16 PM
To: sqloptdb2@toadworld.com
Subject: RE: [SQL Optimizer for IBM DB2 LUW - Discussion Forum] Index advisory for SQL Optimizer for DB2

RE: Index advisory for SQL Optimizer for DB2

Reply by Alex Luk

Hi wmasad,

Thank you for your interest in the product. The lastest version 5.5.0 of SQL Optimizer for DB2 z/OS does include a feature to generate index alternatives for a single SQL statement. After entering or pasting your SQL statement in the editor, click on the :Generate Index" button to start the process. A list of index alternatives will be returned and then you can test run the alternatives to find the best.

Thanks,
Alex

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from SQL Optimizer for DB2 Forum notifications altogether.
SQL Optimizer for IBM DB2 LUW - Discussion Forum

Flag this post as spam/abuse.


Virus-free. www.avast.com