Hie,
I've just created Bug 9681 to propose to add some indexes in
database.
Those indexes are very important to speed up SQL queries, sometimes
100x faster.
I think it can help form some queries in code but mainly for
statistical reports.
Feel free to discuss.
Best regards,