thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Search Optimization Service

A Snowflake Enterprise feature that builds a persistent search access path to speed selective point lookups, substring searches and VARIANT field searches.

Definition

Search optimization helps queries that return a few rows from large tables with equality or IN filters on high-cardinality columns, which clustering cannot serve well. It is maintained serverlessly and incurs storage and compute costs.

Example

ALTER TABLE customers ADD SEARCH OPTIMIZATION ON EQUALITY(email);

Exam tip

Needle-in-a-haystack lookups by ID or email = search optimization; range scans on dates = clustering.

Related terms