This index would reduce system resource consumption.
Below is an example query captured with the index:
select @TESTSEGMENTID = MD.TESTSEGMENTID,
@SEGMENTID = MD.SEGMENTID from MKTSEGMENTATIONDATA_90C0B288_6FD8_45B8_AE64_5AB89B2EA21C MD where MD.DONORID=@CONSTITUENTID
CREATE INDEX IX_MKTSEGMENTATIONDATA_90C0B288 ON MKTSEGMENTATIONDATA_90C0B288_6FD8_45B8_AE64_5AB89B2EA21C(DONORID);
This improvement would help everyone on the system as it reduces database system resource consumption (IO and CPU)
|Organization Name (Please enter full organization name)||Father Flanagan's Boys' Home|