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.

Screenshot showing a query result listing four warehouses and the V-Order state for each.