> -----Original Message-----
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 10:32 AM
> To: CF-Talk
> Subject: Re: all records deleted from table
>
> PostgreSQL has them. I would expect DB2 to have them as wll,
> since IBM
> funded some research into this:
> http://simon.cs.cornell.edu/home/praveen/papers/partindex.de95
.ps.Z
(If you already know a little about indexing concepts it is interesting,
but it is not a beginners guide.)
Typical indexing would have a unique index over the primary key field
without any predicate, and all other indexes only over the current
records. In this case that would be:
CREATE INDEX currentRecords_idx
ON table (field) WHERE dtDeleted IS NOT NULL;
I may be reading this wrong, but I think that you'd accomplish nearly
the same thing (albeit in two steps) in SQL Server by indexing a view.
You'd have to take the view into account on the select however... So
many this doesn't do the same thing at all. But it's one way of getting
close at least.
Jim Davis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
