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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to