Hi there. Yes the doc is up to date.
Now for those below you’ll only need to do that if you enable stats in XWiki (off by default):
create index xws_number on xwikistatsdoc (XWS_NUMBER);
create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
create index xwr_number on xwikistatsreferer (XWR_NUMBER);
create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME);
create index xwr_referer on xwikistatsreferer (XWR_REFERER(50));
create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255));
create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255));
create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
create index xwv_number on xwikistatsvisit (XWV_NUMBER);
Indeed that’s correct, this is not dependent on how XWiki is installed, and we’re missing info about this…
I’ve added it to https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/#HInstallationMethods for now.
The reason they were not mentioned is because they’re only to get better performance and not absolutely required. On the performance page there are plenty of other tips to increase performance too.
Now that’s a good catch and I’ve added the info to https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/#HInstallandconfigureaRelationalDatabase
Thanks!