title: Search Optimization Service in Snowflake is not used
body: <p>I have a Question on Search Optimization Service on Snowflake:</p>
  <p>I have two tables Store_sales and Customers in my db and both are enabled with search optimization service, i have a query which does filter on date column in store_sales.date column as below by joining customer data:</p>
  <pre><code>select ss.SS_SOLD_DATE_SK, ss.SS_ITEM_SK, c.C_FIRST_NAME from STORE_SALES ss
  join SS_CUSTOMER c 
  on ss.SS_CUSTOMER_SK = c.C_CUSTOMER_SK  
  where ss.SS_SOLD_DATE_SK = 2451148;</code></pre>
  <p>In the execution plan i am seeing Search optimization service used while scanning STORE_SALES table whereas Search Optimization is not used on SS_CUSTOMER table, due to this full table scan query is slowing down, similarly if i have point lookup filter on customer and querying STORE_SALES search optimization on STORE_SALES is not used. How to use search optimization service which is ON both tables to be used on both the tables?</p>
  <p>Below is execution plan:</p>
  <p><a href="https://i.stack.imgur.com/fPqh8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fPqh8.png" alt="enter image description here" /></a></p>