we will soon redo some profiling on Jahia 4.1 to provide an updated indexes list.
As indexes may also vary a bit depending on the type of content and type of usage (mostly read or write) , you can still use the SQLProfiler ( http://sqlprofiler.jahia.org/ ) or any other SQL profiling tool to obtain a "personnalized" indexes list.
best regards,
Michel Romy
Is it possible to publish an updated version of the suggested table indexes in relation to Jahia 4.1?
The "create index" statements still refer to the jahia_slide_* tables, but they have been replaced since then.
cfr http://www.jahia.org/jahia/Jahia/devzone/pid/454#6
tia
pascal
