From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "David Garamond" <lists(at)zara(dot)6(dot)isreserved(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Partial index in other DB |
Date: | 2004-02-08 12:32:21 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE34B166@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>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 CLUSTERED index basically puts the storage of the table into an
index instead of a heap. It still indexes the whole table. In this, it
works like postgresqls CLUSTER except it *keeps* the table clustered at
all times. (This is why you can have only one clustered index / table).
Other indexes just point to pages in the clustered index instead of the
heap.
You might be able to use an indexed view to get the same result,
depending on exactly what your application needs are. But it's definitly
not the same thing.
Can't say anything about the other DBs.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2004-02-08 14:02:01 | Repost: postmaster growing to consume all memory |
Previous Message | David Garamond | 2004-02-08 11:42:55 | Partial index in other DB |