CREATE INDEX jahia_acl_index ON jahia_acl ( id_jahia_acl ); 
CREATE INDEX jahia_acl_index2 ON jahia_acl ( parent_id_jahia_acl,id_jahia_acl ); 

CREATE INDEX jahia_ctn_def_index ON jahia_ctn_def ( id_jahia_ctn_def ); 
CREATE INDEX jahia_ctn_def_properties_index ON jahia_ctn_def_properties ( ctndefid_jahia_ctn_def_prop ); 
CREATE INDEX jahia_ctn_entries_index ON jahia_ctn_entries ( rights_jahia_ctn_entries ); 
CREATE INDEX jahia_ctn_entries_index2 ON jahia_ctn_entries ( id_jahia_ctn_entries,workflow_state );
CREATE INDEX jahia_ctn_entries_index3 ON jahia_ctn_entries ( pageid_jahia_ctn_entries,workflow_state ); 
CREATE INDEX jahia_ctn_entries_index4 ON jahia_ctn_entries ( listid_jahia_ctn_entries,workflow_state,rank_jahia_ctn_entries,id_jahia_ctn_entries ); 
CREATE INDEX jahia_ctn_entries_index5 ON jahia_ctn_entries ( id_jahia_ctn_entries,rights_jahia_ctn_entries ); 

CREATE INDEX jahia_ctn_lists_index ON jahia_ctn_lists ( id_jahia_ctn_lists,workflow_state ); 
CREATE INDEX jahia_ctn_lists_index2 ON jahia_ctn_lists (  parententryid_jahia_ctn_lists,pageid_jahia_ctn_lists ); 
CREATE INDEX jahia_ctn_lists_index3 ON jahia_ctn_lists ( id_jahia_ctn_lists, parententryid_jahia_ctn_lists );
CREATE index jahia_ctn_lists_index4 ON jahia_ctn_lists ( pageid_jahia_ctn_lists, ctndefid_jahia_ctn_lists );
CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists ( parententryid_jahia_ctn_lists,id_jahia_ctn_lists );  
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop ( ctnlistid_ctnlists_prop ); 
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct ( rank_jahia_ctn_struct,ctnsubdefid_jahia_ctn_struct ); 
CREATE index jahia_ctn_struct_index2 ON jahia_ctn_struct( objdefid_jahia_ctn_struct );
CREATE INDEX jahia_ctn_struct_index3 ON jahia_ctn_struct ( objtype_jahia_ctn_struct,objdefid_jahia_ctn_struct,ctnsubdefid_jahia_ctn_struct ); 
CREATE INDEX jahia_ctn_struct_index4 ON jahia_ctn_struct ( ctnsubdefid_jahia_ctn_struct,rank_jahia_ctn_struct ); 

CREATE INDEX jahia_fields_data_index ON jahia_fields_data ( pageid_jahia_fields_data,workflow_state,ctnid_jahia_fields_data); 
CREATE INDEX jahia_fields_data_index2 ON jahia_fields_data ( id_jahia_fields_data,workflow_state,ctnid_jahia_fields_data ); 
CREATE INDEX jahia_fields_data_index3 ON jahia_fields_data ( id_jahia_fields_data,workflow_state,pageid_jahia_fields_data ); 
CREATE INDEX jahia_fields_data_index4 ON jahia_fields_data ( id_jahia_fields_data,pageid_jahia_fields_data,ctnid_jahia_fields_data ); 
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data ( rights_jahia_fields_data ); 
CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data ( ctnid_jahia_fields_data, rank_jahia_fields_data,id_jahia_fields_data); 
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data ( value_jahia_fields_data,type_jahia_fields_data,workflow_state,version_id );
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data ( pageid_jahia_fields_data,ctnid_jahia_fields_data,rank_jahia_fields_data,id_jahia_fields_data ); 
CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data ( pageid_jahia_fields_data,workflow_state,id_jahia_fields_data ); 
CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data ( pageid_jahia_fields_data,fielddefid_jahia_fields_data );


CREATE INDEX jahia_fields_def_index ON jahia_fields_def ( id_jahia_fields_def ); 
CREATE index jahia_fields_def_index2 ON jahia_fields_def ( jahiaid_jahia_fields_def );
CREATE index jahia_fields_def_index3 ON jahia_fields_def ( jahiaid_jahia_fields_def,name_jahia_fields_def );
CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ( flddefid_jahia_fields_def_prop ); 
CREATE INDEX jahia_fields_def_prop_index2 ON jahia_fields_def_prop ( type_jahia_fields_def_prop,default_jahia_fields_def_prop ); 
CREATE INDEX jahia_fields_def_extprop_index ON jahia_fields_def_extprop ( id_jahia_fields_def ); 

CREATE INDEX jahia_link_index ON jahia_link ( right_oid ); 
#CREATE INDEX jahia_link_index2 ON jahia_link ( type, left_oid );

CREATE INDEX jahia_pages_data_index ON jahia_pages_data ( id_jahia_pages_data,workflow_state, version_id);
CREATE INDEX jahia_pages_data_index2 ON jahia_pages_data ( workflow_state,parentid_jahia_pages_data,version_id,id_jahia_pages_data ); 
CREATE INDEX jahia_pages_data_index3 ON jahia_pages_data ( rights_jahia_pages_data ); 
CREATE INDEX jahia_pages_data_index4 ON jahia_pages_data ( parentid_jahia_pages_data ) ;
CREATE INDEX jahia_pages_data_index5 ON jahia_pages_data ( workflow_state,parentid_jahia_pages_data,id_jahia_pages_data,version_id );
CREATE INDEX jahia_pages_data_index6 ON jahia_pages_data ( parentid_jahia_pages_data,workflow_state,id_jahia_pages_data,version_id );
CREATE INDEX jahia_pages_data_index7 ON jahia_pages_data ( parentid_jahia_pages_data,id_jahia_pages_data,version_id );
CREATE INDEX jahia_pages_def_index ON jahia_pages_def ( id_jahia_pages_def ); 
CREATE INDEX jahia_pages_def_prop_index ON jahia_pages_def_prop ( id_jahia_pages_def_prop ); 
CREATE INDEX jahia_pages_def_prop_index2 ON jahia_pages_def_prop ( name_pages_def_prop,value_pages_def_prop ); 

CREATE INDEX jahia_locks_index ON jahia_locks ( name_locks,targetid_locks,action_locks ); 

CREATE INDEX jahia_user_prop_index ON jahia_user_prop ( id_jahia_users,provider_jahia_user_prop,userkey_jahia_user_prop ); 
CREATE INDEX jahia_users_index ON jahia_users ( name_jahia_users,siteid_jahia_users ); 
CREATE INDEX jahia_users_index2 ON jahia_users ( siteid_jahia_users ); 
CREATE INDEX jahia_users_index3 ON jahia_users ( key_jahia_users );