Re: INDEX Question

And another similar question:

Does the select statement that follows mean that it does the concatenation automatically to use the index above? Since it is a composite index, does that mean the I would need to create a separate index if I want to access the Name (or Skill) column separately and efficiently (ie. indexed)? Thanks.

select Column1, Column2, Column3

   from TABLE
where Column1 = 'THIS'

   and Column2 = 'THAT';

• Roy Wagner - "When driving my Miata, I always get to where I'm going before I want to stop driving it."