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
Hi.
On Sat, May 11, 2002 at 11:40:03PM -0300, [EMAIL PROTECTED] wrote:
> Hi,
>
> A field can belongs to 2 or more indexes?
Yes. Why didn't you simply try?
Bye,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting,
> Just a couple of questions regarding indexes...
>
> Can I have multiple indexes on the same column?
Yes, but it's kind of pointless.
> Will this decrease performance when inserting?
Yes.
> Can you create and remove indexes after the creation of the table?
Yes.
---