Hi Michael,

> If I have a table where there is a primary key on field1 and field2.
> Do I then gain anything from making an index on both fields or a
> combined on both fields ?

If you have a primary key constraint on those fields, an index is
automatically created.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com