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

From: Paul Mansour <paul_at_carlislegroup.com>
Date: 15 May 2006 11:03:32 -0700
Message-ID: <1147716212.929302.196840@j33g2000cwa.googlegroups.com>

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 - 13:03:32 CDT