>Can anyone confirm following ?
>Create table t ( t1 integer primary key , t2 text unique , t3 ... )
>The table is created with 2 indexes :
>First index : t1 ( the primary key )
>Second index : t2 because t2 has the attribute unique
Being a pedant, no, there is only one external index (on t2). t1, being an
integer primary key, is the row Id and keyed directly in the table.
Nitpicking aside, yes. t2 is indexed.
>Thank's in advance
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS