I am trying to solve the following problem. I have a certain column,
to_state, that can take a finite set of values. I want to make sure that
my query always returns those sets of finite values, even if not all of
the values are represented in the results. In essence, I am looking to
expand the res
I have created a table where a unique row is defined by 5 columns and
have created an index on these 5 columns. If I then do a select with a
where clause that only consists of 3 of these columns, will I get the
speed benefits from the index that I have created, or will I need to
create another inde