Re: In an RDBMS, what does "Data" mean?
From: Paul <paul_at_test.com>
Date: Tue, 08 Jun 2004 13:38:36 +0100
Message-ID: <Zqixc.12382$NK4.1717725_at_stones.force9.net>
Date: Tue, 08 Jun 2004 13:38:36 +0100
Message-ID: <Zqixc.12382$NK4.1717725_at_stones.force9.net>
Laconic2 wrote:
> In particular, entity integrity and referential integrity constraints can
> be used to "prove" that, in certain cases,
> "SELECT ALL" and "SELECT DISTINCT" will yield identical results. This can
> result in generating a faster strategy.
> The information that a given snapshot happens to conform to a constraint
> could be made available by examining the snapshot, rather than examining the
> constraint, but the cost of obtaining that knowledge would be prohibitive.
Paul. Received on Tue Jun 08 2004 - 14:38:36 CEST