This seems to be the same index expert that’s in Toad that is a descendant of the Lecco tool. Is it? I’ve found that it doesn’t work well in our highly indexed OLTP environment. We’ve been looking for something that replaces the late SQL Analyze tool from Oracle that was lost when they went to 10g. That tool was flawless in sql analysis and almost always reduced query cost 95% +. It not only recommended new indexes, but mostly recommended modifiying existing indexes to more efficient orders and columns. It worked like magic.
Using the Lecco tool for years and now the Toad tool, I’ve found it severly lacking, returning with “No Indexes required” on most of the queries no matter how high the intelegence is set. The few times it does offer an alternative, it’s either minor or overtly obvious. It never offers solutions on complex queries.(200 line, 10+ table joins etc…) Is this new tool a better version? Or just the Toad stuff repackaged?