(8) By Hardy on 2020-07-31 22:03:04 in reply to 4 updated by 8.1
Hi, yes, Relations_Index1: 0.0177s Relations_Index2: 99.35s Index2/Index1 = 5613! Index1 must be the fastest because there is at most one match (the statistics are matching exactly in my case). Regards, Hartwig
(8.1) By Hardy on 2020-07-31 22:25:06 edited from 8.0 in reply to 4 [link]
Hi, yes, Relations_Index1: 0.0177s Relations_Index2: 99.35s Index2/Index1 = 5613! Index1 must be the fastest because there is at most one match (the statistics are matching exactly in my case). Regards, Hartwig PS: Is there also a possibility to enforce the order of the index usage?