> Is it possible to make a field unique without specifying an
> index on it?

Technically, yes.

Partically, no.

You could create a trigger which would need to perform a select to
ensure/enforce uniqueness, but if the table is large... that could end
up being a very expensive/time consuming process.

A unique index is really the way to go.


Sean