与sqlServer类似,我可以做以下操作
- create index TimeSeriesPeriodSs1 on TimeSeriesPeriod (validationStatus,completionStatus)
- where completionStatus= N'Complete'
- and validationStatus= N'Pending'
解决方法
您可以在Oracle中创建基于函数的索引,利用NULL值不存储在b-tree索引中的事实.就像是
- CREATE INDEX TimeSeriesPeriodSs1
- ON TimeSeriesPeriod(
- (CASE WHEN completionStatus = 'Complete' AND validationStatus = 'Pending'
- THEN validationStatus
- ELSE NULL
- END),(CASE WHEN completionStatus = 'Complete' AND validationStatus = 'Pending'
- THEN completionStatus
- ELSE NULL
- END)
- );
