G
George Potemkin
Guest
> If I read all records instead of just the first 100, the times are similar for either index. By default SeekRatio.p reads 10,000 first records and it's still only 25% of the records in your tables. The "Artikel-Id" index shown a very bad number. Could it be a some "globally unique" ID, in other words some random value that is not correlated with the order of their creation (and with their location inside database)? > To exclude buffering issues (db buffering is at 99%) I repeat the same query 3 times I missed this part. Seek ratio has a meaning only when records are retrieved from disks.
Continue reading...
Continue reading...