it looks like the optimizer is doing table scan instead of index scan if I select column that are not part of the index!.I created the following table and indexCREATE TABLE customer_lastseen_products ( customer_ref_value STRING(50) NOT NULL, customer...