Performance & Governance Features, Recapped
Three performance features get their full treatment in Part 2 and are only cross-referenced here for completeness of the domain map. The Search Optimization Service (Part 2) builds a hidden access path that speeds selective lookups on large tables: equality, substring, VARIANT fields and geospatial. You turn it on with ALTER TABLE ... ADD SEARCH OPTIMIZATION. Secondary indexes (CREATE INDEX, generally available since October 2026) do the same job for chosen columns or expressions of a standard table, and their maintenance is billed as search optimization. The Query Acceleration Service (Part 2) borrows elastic serverless compute for the scan-heavy portion of eligible queries; it's a warehouse setting, on by default for new standard warehouses. All three are Enterprise-edition features.
- Writing a UDF that tries to run an INSERT or UPDATE. UDFs never perform DML; that's a stored procedure's job.
- Forgetting a newly created task starts suspended and never runs until explicitly resumed.
- Calling FLATTEN in the SELECT list, or chaining a second FLATTEN without LATERAL, instead of putting it in the FROM clause next to its source table.
- Treating an external table and an Iceberg table as interchangeable. Only Iceberg tables get write support and full pruning.

