#1 Improvement in Index generation

[Michel Romy]

Dear sir,

Your SQL Profiler is really helpful for my project, but I
have two comments/features request that I would like
to see implemented in a future release of your tool:

1) Use of multicolumn indexed:

When you create a multicolumn index, the order of the
fields is important. A three col. index (col1, col2, col3)
can also be used with request on col1 + col2 or on col1
only, but requests on col2 + col3 or col3+col1 won't use
the index. Here are links to Postgres and MySQL on this :

http://darkstar.ist.utl.pt/mysql/doc/en/MySQL_indexes.h
tml
http://www.postgresql.org/docs/7.3/interactive/indexes-
multicolumn.html

I think this is not taken into account in the current
version.

2) Choice of how many indexes are generated:

I would also like to be able to select in the bottom panel
which indexes I would like to create. Currently indexes
for all the requests types are generated.

Thank you to take these features request in
consideration when you have time to work on this
project again.

Cheers,

Michel

[Serge Huber]

Logged In: YES
user_id=6951

I have implemented the version part of this request in
version 0.2.
I'm not sure when I'll have the time to do the second part
but it will be in a later version so I am not yet closing
this request.

But for the future, PLEASE seperate requests. Regrouping
them like this makes it much more difficult for me to track
them.