CodeXpert - Professional Editon vs Epert Edition

Toad for Oracle
1

Hi all,
Is there any difference between the CodeXpert of Toad Professional edition and Xpert Edition.

I have read that Xpert edition has all the stuff of professional edition plus an SQL optimizer. Does this has any impact on the CodeXpert functionality compared to the CodeXpert in Professional edition.

I am only interested in CodeXpert and its full capacity so do not want to buy more.

Please advice…

2

The Xpert Edition adds a feature to the CodeXpert window - the SQL Scanner.

As you run your code against the rules, you can optionally scan any embedded SQL
query for bad plans that are ripe for tuning.

If you are happy with the code analysis and have never used the SQL optimizer to
re-write your bad queries for you, then Professional is what you want.