[GENERAL] Right Join Question

2009-10-22 Thread Bierbryer, Andrew
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

[GENERAL] Index Question

2009-10-19 Thread Bierbryer, Andrew
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