3 ms·
Looking up something by its clustered index is indeed pretty easy. That's not the only access pattern into most data sets, which is where tags can be handy. I
by sokoloff 6y ago
Looking up something by its clustered index is indeed pretty easy. That's not the only access pattern into most data sets, which is where tags can be handy.
I agree with your last two points, as my family's digital photos are also stored in a fairly similar clustered index style where you have to know the date at least pretty closely to start your search unless you want to scan "all Thanksgivings" [which itself is just a series of clustered index lookups]