[Blobs] does not have a clustered index.[History] does not have a clustered index.[Items] does not have a clustered index.[Links] does not have a clustered index.[Tasks] does not have a clustered index.
我在SQL Server中有一个datetime列(AdmitDate)和一个varchar列(Status)的非聚集索引。现在的问题是,我只根据datetime列过滤结果(仅在AdmitDate列上没有索引)。select ClientName, ID where
(PatientVisit.AdmitDate between '2010-01-01 00:00:00.000' AND '