This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
alter session set USE_CACHED_RESULT = FALSE; | |
alter session set query_tag = 'resultcache'; | |
use warehouse benchmark; | |
alter warehouse benchmark set warehouse_size = XSMALL; | |
select c.* | |
from cost.altimate.store_sales_price sp | |
join cost.altimate.customer c | |
on sp.ss_customer_sk = c.c_customer_sk | |
where c_birth_country like '%REP%' |