-- Create indexes in the eiaodw schema. 
-- Notice that an index is created implicitly for each primary key.

-- On TestResult_T
create index TestResult_T_SubjectID_IDX on eiaodw.TestResult_T(TestRunID, SubjectID);
create index TestResult_T_ResultID_IDX on eiaodw.TestResult_T(TestRunID, ResultID);
create index TestResult_T_BarrierComputationVersionID_IDX on eiaodw.TestResult_T(TestRunID, BarrierComputationVersionID);

-- On Date_T
create index Date_T_MonthNumberInYear_DateID_IDX on Date_T(MonthNumberInYear, DateID);
create index Date_T_MonthName_DateID_IDX on Date_T(MonthName varchar_pattern_ops, DateID);
create index Date_T_QuarterName_DateID_IDX on Date_T(QuarterName varchar_pattern_ops, DateID);
create index Date_T_QuarterNumberInYear_DateID_IDX on Date_T(QuarterNumberInYear, DateID);
create index Date_T_Year_DateID_IDX on Date_T(Year, DateID);

-- On Subject_T
--create index Subject_T_Encoding_SubjectID_IDX on eiaodw.Subject_T(Encoding varchar_pattern_ops, SubjectID);
--create index Subject_T_Server_SubjectID_IDX on eiaodw.Subject_T(Server varchar_pattern_ops, SubjectID);
--create index Subject_T_OperatingSystemFamily_SubjectID_IDX on eiaodw.Subject_T(OperatingSystemFamily varchar_pattern_ops, SubjectID);
--create index Subject_T_Language_SubjectID_IDX on eiaodw.Subject_T(Language varchar_pattern_ops, SubjectID);
--create index Subject_T_LanguageAbbreviation_SubjectID_IDX on eiaodw.Subject_T(TestRunID, LanguageAbbreviation varchar_pattern_ops, SubjectID);
--create index Subject_T_LanguageFamily_SubjectID_IDX on eiaodw.Subject_T(LanguageFamily varchar_pattern_ops, SubjectID);
--create index Subject_T_LanguageFamilyAbbreviation_SubjectID_IDX on eiaodw.Subject_T(LanguageFamilyAbbreviation varchar_pattern_ops, SubjectID);
--create index Subject_T_URL_SubjectID_IDX on eiaodw.Subject_T(URL varchar_pattern_ops, SubjectID);
create index Subject_T_Site_IDX on eiaodw.Subject_T(TestRunID, SiteID, ResourceVersionID, SubjectID);
create index Subject_T_ResourceVersion_IDX on eiaodw.Subject_T(TestRunID, ResourceVersionID, SubjectID);
--create index Subject_T_TopLevelDomain_SubjectID_IDX on eiaodw.Subject_T(TopLevelDomain varchar_pattern_ops, SubjectID);
--create index Subject_T_Country_SubjectID_IDX on eiaodw.Subject_T(Country varchar_pattern_ops, SubjectID);
create index Subject_T_CountryAbbreviation_SubjectID_IDX on eiaodw.Subject_T(CountryAbbreviation varchar_pattern_ops, SubjectID);
create index Subject_T_NutsLevel1_SubjectID_IDX on eiaodw.Subject_T(TestRunID, Nuts1Code varchar_pattern_ops, SubjectID);
create index Subject_T_NutsLevel2_SubjectID_IDX on eiaodw.Subject_T(TestRunID, Nuts2Code varchar_pattern_ops, SubjectID);
create index Subject_T_NutsLevel3_SubjectID_IDX on eiaodw.Subject_T(TestRunID, Nuts3Code varchar_pattern_ops, SubjectID);


-- BarrierComputationVersion_T
create index BarrierComputationVersion_T_BarrCompID_BarrCompVerID_IDX on eiaodw.BarrierComputationVersion_T(BarrierComputationID, BarrierComputationVersionID);
create index BarrierComputationVersion_T_WCAGMaj_WCAGMin_BarrCompVerID_IDX on eiaodw.BarrierComputationVersion_T(WCAGMajor, WCAGMinor, BarrierComputationVersionID);


-- 
-- Indexes benefitting the C-WAM implementations:
--
-- On DisabilityGroupRelevance_Fcui
create index DisabilityGroupRelevance_Fcui_T_DisGrpID_BarrCompID_BarPrb_IDX on eiaodw.DisabilityGroupRelevance_Fcui_T(DisabilityGroupID, BarrierComputationID, BarrierProbability); 

-- On Scenario
create index Scenario_T_TestRunID_SiteID_ScenarioID_IDX on scenario_t(TestRunID, SiteID, ScenarioID);