Disable V-Order on Warehouse in Microsoft Fabric
Applies to: ✅ Warehouse in Microsoft Fabric
This article explains how to disable V-Order on Warehouse in Microsoft Fabric.
Disabling V-Order causes any new Parquet files produced by the warehouse engine to be created without V-Order optimization.
Caution
Currently, disabling V-Order can only be done at the warehouse level, and it is irreversible: once disabled, it cannot be enabled again. Users must consider all the performance impact of disabling V-Order before deciding to do so.
Disable V-Order on a warehouse
To permanently disable V-Order on a warehouse, use the following T-SQL code to execute ALTER DATABASE ... SET in a new query window:
ALTER DATABASE CURRENT SET VORDER = OFF;
Check the V-Order state of a warehouse
To check the current status of V-Order on all warehouses, of your workspace, use the following T-SQL code to query sys.databases in a new query window:
SELECT [name], [is_vorder_enabled]
FROM sys.databases;
This query outputs each warehouse on the current workspace, with their V-Order status. A V-Order state of 1 indicates V-Order is enabled for a warehouse, while a state of 0 indicates disabled.
