From: Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> The null value is used to find most recent revisions of objects.. Thanks for the suggestion of infinity ! I'll try it. My partitioning table design model always uses a partitioning column that is 100% static since that guarantees that rows are not constantly moving between partitions (with index update overhead etc). In this scenario I’d use a “StartTime” column to anchor the row in a partition. The relatively few rows with a null EndTime don’t need the power of partitioning, just an index to find them. Mike Sofen |
