Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jswartsel
Starting Member
1 Post |
 Posted - 2009-11-23 : 11:38:16
|
| Hi everyone,I'm trying to decide whether or not the best approach for "logical deletion" in our database would be to have a nullable DATETIME column in a given table that is stamped when the record is "deleted".One of several concerns that I have is how to index a table like this. For example, would I include this column in the clustered index? Should it be the first column in order? Generally speaking, I'll ONLY be selecting non-"deleted" rows (WHERE DeleteDateTime IS NULL) so I know I'd want to group all records where this is true together. Thanks!Justin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-23 : 11:40:12
|
| i would do this by means of Status column for better clarity . values will be Open & deleted |
 |
|
|
|
|
|
Using "Deleted On" DATETIME column and Indexing