Hi Experts,
Below are the original design and modifications recommended by us. Do i need to add anything or did i miss anything?
--Original Table design
CREATE TABLE ASC
(
[ASCID] UNIQUEIDENTIFIER NOT NULL,
[MuthalID] UNIQUEIDENTIFIER NOT NULL,
[ConsumableTypeID] UNIQUEIDENTIFIER NOT NULL,
[RemainingYield] INT,
[ReOrderDate] DATETIME,
[Recommendation] NVARCHAR (50),
[CreatedDate] DATETIME NOT NULL,
[CreatedBy] UNIQUEIDENTIFIER NULL,
[ModifiedDate] DATETIME NOT NULL,
[ModifiedBy] UNIQUEIDENTIFIER NULL
)
--Recommendataion from our side.
1)Create a Clustered Index on ASCID.
2)Non Clustered Index on MuthalID.
3)Non Clustered Index on MuthalId,ConsumableTypeId
4)Change ASCID data type to INT (with Identity) to reduce the size of clustered index
TIA