#1 Improvement in Index generation

open
nobody
5
2003-08-08
2003-08-08
Michel Romy
No

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

Discussion

  • Serge Huber
    Serge Huber
    2003-10-14

    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.