I have a Table with the following Schema
CREATE TABLE [dbo].[ProjectNotifications](
[ProjectNotificationID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[DomainValueID] [int] NOT NULL,
[StatusId] [int] NULL,
CONSTRAINT [PK_ProjectNotification] PRIMARY KEY CLUSTERED
(
[ProjectNotificationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
This table will probably have more Inserts and Updates. So, while brain storming we came up with an Idea of a Flag column called Status which indicates if the row is active or not. Lets say that as Status
Now, we need to evaluate if updating the flag column to a NULL or deleting it entirely will serve the purpose. we are curious to know which is better design.
If we go with updating the status column instead of Deleting a row, Will that doesn't mob the data with unused rows going forward?