Re: TRM - Morbidity has set in, or not?

J M Davitt wrote regarding inverted indexes:

> This has huge significance: all values in a date domain covering
> hundreds of years require fewer than 100,000 values. Time-of-day
> precise to a second requires only 86,000 values. Given these domains,
> adding records to a system would require no new values -- the domains
> can be established before the first data arrive

But wouldn't adding a row require an index for each (indexed) column? In the case of a date domain, the index value will in all likelyhood be the same size as the date value it points to. Correct? Or am I missing something? How, in the case of a date or time domain, does this have "huge significance"? Received on Mon May 15 2006 - 20:03:32 CEST