[Deploying Sakai] Slow site type request

[Jean-Francois Leveque]

Hi,

The following request is slow (> 2 s) on my DB server more than an 
average of once every other day:
select distinct TYPE from SAKAI_SITE order by TYPE;

Creating the following index on a test server improves performance a lot:
create index SAKAI_SITE_TYPE on SAKAI_SITE (TYPE);

Has anyone else already tried indexing SAKAI_SITE on TYPE to improve the 
performance of this request?

Does anyone think we shouldn't add this index to the next DB update scripts?

Cheers,

J-F