Full text index before or after non-clustered index

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

almurph [ Mi, 20 Dezember 2006 13:26 ] [ ID #1573543 ]

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

almurph [at] 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

Michael Austin [ Do, 21 Dezember 2006 02:24 ] [ ID #1574691 ]

Datenbanken » mailing.database.mysql » Full text index before or after non-clustered index

Vorheriges Thema: MySQL performance question on SELECT and JOIN. experts only
Nächstes Thema: SELECT multiple rows with average of a range of values