Re: [GENERAL] Partial index in other DB

2004-05-09 Thread Magnus Hagander
>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? No. A CLUSTER

[GENERAL] Partial index in other DB

2004-02-08 Thread David Garamond
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