Sec idx for tables

Database
Enthusiast

Sec idx for tables

Hi Dieter!

What would be the easiest way to find if the tables in a database need a sec idx?
If I run a Sel * for each table through the sec idx wizard , will it help?
This is to help imprve the overall perf.

Thanks!
1 REPLY
Enthusiast

Re: Sec idx for tables

Index wizard needs a workload comprised of typical queries to be effective. You can (I think) pull that from DBQL in the tool or take the queries and build a workload with them manually in the tool. Doing a SELECT * on all tables won't tell you much about secondary indexes. You need to know how they are actually used.

And, as always, when applying any kind of indexing, look at the explain plan of the queries you are targeting before and after. If the plan doesn't improve enough, drop the indexes.