On Tue, 2004-02-10 at 13:20, Rod Taylor wrote:
> > >http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
>
> > Notice the Snapshot Isolation. Sounds like MVCC for MSSQL?
>
> Actually, the one I noticed was the ability to add or rebuild indexes on
> the fly. That is a pretty slick trick.
>
I was trying to decide how much better this was than
BEGIN;
DROP INDEX foo ON bar;
CREATE INDEX foo ON bar;
COMMIT;
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
