Personal tools

SRB:Informix Indexes

From Adapt

Revision as of 17:39, 16 September 2008 by Toaster (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
--
-- help userdefined metadata searches (object)
--
create index MDAS_AD_MDATA_DATA_ID on MDAS_AD_MDATA(DATA_ID)
create index MDAS_AD_MDATA_USERDEF_METASTR0 on MDAS_AD_MDATA(USERDEF_METASTR0)
create index MDAS_AD_MDATA_USERDEF_METASTR1 on MDAS_AD_MDATA(USERDEF_METASTR1)
create index MDAS_AD_MDATA_USERDEF_METASTR2 on MDAS_AD_MDATA(USERDEF_METASTR2)

--
-- help userdefined metadata searches (collection)
--
create index MDAS_AD_COLLMDATA_DATA_GRP_ID on MDAS_AD_COLLMDATA(DATA_GRP_ID)
create index MDAS_AD_COLLMDATA_USERDEF_METASTR0 on MDAS_AD_COLLMDATA(USERDEF_METASTR0)
create index MDAS_AD_COLLMDATA_USERDEF_METASTR1 on MDAS_AD_COLLMDATA(USERDEF_METASTR1)
create index MDAS_AD_COLLMDATA_USERDEF_METASTR2 on MDAS_AD_COLLMDATA(USERDEF_METASTR2)

--
-- help directory listing speed & file inserts
--
create index MDAS_AD_REPL_DATA_ID on MDAS_AD_REPL (data_id);
create index MDAS_AD_REPL_DATA_NAME on MDAS_AD_REPL (data_name);
create index MDAS_AD_REPL_PATH_NAME on mdas_ad_repl (path_name);
create index MDAS_AD_REPL_DATA_GRP_ID on MDAS_AD_REPL (DATA_GRP_ID);
create index MDAS_TD_DATA_GRP_DATA_GRP_NAME on MDAS_TD_DATA_GRP(data_grp_name);
create index MDAS_TD_DATA_GRP_PARENT_GRP_NAME on MDAS_TD_DATA_GRP(PARENT_GRP_NAME);

--
-- speeds up deletes
--
create index MDAS_AD_ACCS_DATA_ID on mdas_ad_accs(data_id);
create index MDAS_AD_REPL_CONTAINER_ID on mdas_ad_repl(container_id);
--
-- access permissions
--
create index mdas_ad_accs_data_id on mdas_ad_accs(data_id);
--
-- Excalibur Text Datablade indexes
--
create index etx_MDAS_AD_MDATA_USERDEF_METASTR1 on MDAS_AD_MDATA ( userdef_metastr1 etx_varc_ops ) using etx

-- Main.MikeSmorul - 02 May 2005