...
Code Block | ||||
---|---|---|---|---|
| ||||
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_read_acl_acl_idx on hierarchy_read_acl (acl_id); create index hierarchy_read_acl_id_idx on hierarchy_read_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 hierarchy_ischeckedin_idx ON hierarchy (ischeckedin); 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); reindex table hierarchy; reindex table dublincore; reindex table common; reindex table file; reindex table hierarchy_read_acl; reindex table proxies; |
...