Explanation
Search Optimization can enable significant cost savings when selectively applied to workloads that heavily rely on point-lookup queries. Inefficiencies occur when the feature is either underutilized on critical lookup-heavy tables or unnecessarily enabled on infrequently queried data. Organizations often fail to right-size warehouses after implementation, missing primary cost-saving opportunities. Regular review of query patterns and warehouse sizing is essential.
Relevant Billing Model
- Additional storage charges for Search Optimization metadata maintenance
- Ongoing background compute charges for index maintenance
- Opportunity for warehouse downsizing to offset costs if effectively utilized
Detection
- Assess actual query usage patterns on optimized columns
- Identify instances where Search Optimization exists but query volume is low
- Locate workloads experiencing point-lookup query latency on oversized warehouses
- Evaluate if warehouses remain oversized despite Search Optimization availability
Remediation
- Enable Search Optimization selectively on columns supporting frequent, high-value point-lookup queries
- Reassess and right-size warehouses after enabling the feature
- Remove Search Optimization from tables with low query activity
- Periodically audit configurations against evolving workload patterns