sql server computed column

👤 علی ذوالفقار 📅 1400/10/14 08:05:46 👁️ 590 views

add computed column to speed up the views

ALTER TABLE Table_Name
    ADD Column_Name 
    AS CAST(JSON_VALUE(JSON_DATA_COLUMN,'$.json.path.to.data') AS INT ) 
    PERSISTED

persisted option will force this commuted column to save physical and recalculate after change