• For large updates, index the update_id column to improve performance:

    CREATE TYPE CustomerUpdatesType AS TABLE (

    update_id int identity(1,1) not NULL PRIMARY KEY,

    customer_id int null,

    title nvarchar(16) null,

    first_name nvarchar(32) null,

    last_name nvarchar(32) null,

    phone_number nvarchar(10) null

    );