Page Comparison

create index hierarchy_mixintypes_idx on hierarchy (mixintypes);
create index hierarchy_parentid_idx on hierarchy (parentid);
create index hierarchy_isproperty_idx on hierarchy (isproperty);
create index hierarchy_parentid_id_idx on hierarchy (id, parentid);
create index hierarchy_parentid_isproperty_idx on hierarchy (parentid, isproperty);
create index hierarchy_ischeckedin_idx ON hierarchy (ischeckedin);
create index hierarchy_id_primarytype_idx on hierarchy (id, primarytype);
create index hierarchy_read_acl_id_acl_id_idx on hierarchy_read_acl (id, acl_id);
create index dublincore_title_ordered_idx on dublincore (title asc nulls first);
create index dublincore_created_idx on dublincore (created asc);
create index dublincore_id_created_idx on dublincore (id, created asc);
create index misc_lifecyclestate_idx on misc (lifecyclestate);
create index misc_id_lifecyclestate_idx on misc (id, lifecyclestate);
create index task_targetdocumentid_idx on Task (targetdocumentid);
create index acls_id_user_idx on acls (id);
create index misc_id_all_idx on misc (id, lifecyclepolicy, lifecyclestate);


reindex table hierarchy;
reindex table dublincore;
reindex table common;
reindex table file;
reindex table hierarchy_read_acl;
reindex table proxies;