Re: Multiple indexes on same column

2005-07-22 Thread Alec . Cawley
Andrea Gangini <[EMAIL PROTECTED]> wrote on 22/07/2005 10:17:34: > I have a column in one of my table, which: > - must be unique > - must be indexed because almost all queries are "SELECT .. WHERE > COLUMN LIKE " > > I created two indexes this column, one of type UNIQUE and a normal one

Multiple indexes on same column

2005-07-22 Thread Andrea Gangini
I have a column in one of my table, which: - must be unique - must be indexed because almost all queries are "SELECT .. WHERE COLUMN LIKE " I created two indexes this column, one of type UNIQUE and a normal one, because I thought that the unique index and a normal indexes were differ