I'm building a rather large database - which has around 6.9 million records.

A simple select is taking 6-7 seconds, so I'm now working on optimising and investigating other options. 

An obvious one is to create an index or two.

Sample:

CREATE INDEX "INDEX\_NAME" ON "TABLE\_NAME" (COLUMN\_NAME)

That worked well.

However, I cannot get valid sql syntax to use the index in a select statement. One assumes you can use "select index\_name from table\_name", well at least I did :) However it appears to be invalid, and I cannot for the life of me find an example on the net, which either implies I'm coming from the wrong angle totally, or nobody has documented it...

Any help on how to use indices would be appreciated!