Kay Smoljak wrote: > > Interesting... I mostly use SQL Server, sometimes Interbase (not with CF yet though) >- I don't suppose you have any idea whether Interbase/Firebird supports partial >indexes?
I never heard it does. > Although, the other idea posted in this thread (using a flag and a dtModified field) >is probably a better way to do it - not quite so clean though. It is the same method, only in the first case a NULL date is the key and in the other case a boolean set to false. My point was merely that whether this matters for indexability depends on your DBMS. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4