Full text index before or after non-clustered index

Full text index before or after non-clustered index

am 20.12.2006 13:26:48 von almurph

Folks,

In mySQL should any required non-clusterd indexes be built before or
after a full-text index? Either on the same column or different
columns...

Would appreciate any view/experiences that you may have on this
issue.

Cheers & thanks,
Al.
The mySQL newbie

Re: Full text index before or after non-clustered index

am 21.12.2006 02:24:17 von Michael Austin

almurph@altavista.com wrote:
> Folks,
>
> In mySQL should any required non-clusterd indexes be built before or
> after a full-text index? Either on the same column or different
> columns...
>
> Would appreciate any view/experiences that you may have on this
> issue.
>
> Cheers & thanks,
> Al.
> The mySQL newbie
>

The order of creating indexes is really quite irrelevent.

--
Michael Austin.
Database Consultant