What is the correct way to optimize this query without modifying the column?

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char (5| They frequently restrict on this column, but the query is very inefficient.

What is the correct way to optimize this query without modifying the column?
A . Create a copy of FACT_SALES table with zip_code as integer data type.
B . alter table fact_sales to organize on zip_code. followed by groom.
C . CREATE ORGANIZED view for FACT_SALES table
D . Create a view with a typecast to integer and use view for query purposes

View Answer

Answer: C