Can anybody confirm whether these databases support partial indexes (and
what are their term and syntax)?
SQL Server 2000: I've glanced the T-SQL Reference and it seems it
doesn't support it, though it supports indexing views. CLUSTERED index
is not the same thing, right?
Oracle: I've glanced the 9i SQL Reference and it doesn't seem to support
it. PARTITION-ing is not the same thing, right?
DB2: In the hackers archive, Bruce said that it does support it "using
single-clause predicates".
--
dave