INDEX Question

If you set up an INDEX as follows:

create index TABLE on TABLE(Column1,Column2);

does this set up the index as a concatenated index or as separate indexes for Column1 and Column2?

If it creates a composite index as the book I have indicates, do I have to set up separate indexes on Column1 (or Column2) if I want "indexed" access on only that column; .ie. select * from TABLE where Column1 =
"something";.

Thanks for clarifying this for me!

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