That works faster in sql for creation of an index?

That works faster in sql for creation of an index?

am 23.08.2007 13:18:13 von Picaso.Leonardo

Hello all

That works faster in Mysql for creation of an index:
CREATE INDEX
or
ALTER TABLE tab ADD INDEX


Thanks.

Re: That works faster in sql for creation of an index?

am 24.08.2007 15:35:56 von Shawn Hamzee

== Quote from Picaso.Leonardo ( Picaso.Leonardo@gmail.com)'s article
> Hello all
> That works faster in Mysql for creation of an index:
> CREATE INDEX
> or
> ALTER TABLE tab ADD INDEX
> Thanks.

they both do the same thing, neither one is faster than the other.
--
POST BY: lark with PHP News Reader