Hi,

I was wondering - which index type should I be using in EDB Manager to
specify a field that will be used in a WHERE SQL clause in EDB to
increase the performance of SQL?

The only options I have available are:

Primary Key
Unique key
Foreign, and
Check

.... but none of these seem to make sense to me, as the field is neither
unique, nor a primary, nor a foreign, and doesn't require any check /
constraints at all?

Cheers

Adam.

Adam


You're looking in the wrong place. Take a squint at the tree on the left. If you open up any of the table branches (click on the triangle don't double click) you'll see another branch Indexes. Click on that and you'll be allowed to create an new index.

The create / alter table dialog now only deals with the primary key or constraints.

Roy Lambert

Perfect Roy - thanks for that - got it!

Cheers

Adam.