# Suboptimal Use of Search Optimization Service

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-use-of-search-optimization-service

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Suboptimal Use of Search Optimization Service

## Explanation

Search Optimization can enable significant cost savings when selectively applied to workloads that heavily rely on point-lookup queries. By improving lookup efficiency, it allows smaller warehouses to satisfy performance SLAs, reducing credit consumption.

However, inefficiencies arise when:

- Search Optimization is not enabled on critical lookup-heavy tables, forcing oversized warehouses.

- It is enabled unnecessarily on infrequently queried data, adding avoidable costs.

- Warehouse sizing is not adjusted after Search Optimization is implemented, missing the primary cost-saving opportunity.

Regular review of query patterns and warehouse sizing is essential to maximize the intended benefit of Search Optimization.

## Relevant Billing Model

## Detection

- Identify tables where Search Optimization is enabled and assess actual query usage patterns on optimized columns.

- Detect cases where Search Optimization is enabled but query volume against the indexed columns is low.

- Identify workloads that experience point-lookup query latency but operate on oversized warehouses without Search Optimization.

- Evaluate if warehouses supporting lookup-heavy workloads remain oversized despite Search Optimization being available.

## Remediation

- Enable Search Optimization selectively on columns supporting frequent, high-value point-lookup queries

- After enabling Search Optimization, reassess and right-size warehouses where feasible.

- Remove Search Optimization from tables or columns with low query activity to eliminate unnecessary storage and maintenance costs.

- Periodically audit Search Optimization configurations against evolving workload patterns and business needs.

## Relevant Documentation

[Submit Feedback](https://hub.pointfive.co/inefficiencies/suboptimal-use-of-search-optimization-service)

## At a glance

Reference

CER-0131

Cloud provider

Snowflake

Service

Snowflake Search Optimization Service

Category

[Other](https://www.pointfive.co/efficiency-hub/service-category/other)

Inefficiency type

Suboptimal Configuration and Usage

## Contributed by

- Simar Arora 

### Simar Arora

Value Engineer - FinOps @ Snowflake

[LinkedIn](https://www.linkedin.com/in/simarpreet-arora/)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.