That works faster in sql for creation of an index?

#1 August 23rd, 2007, 12:25 PM

Hello all

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

Thanks.

#2 August 24th, 2007, 02:45 PM

== Quote from Picaso.Leonardo ( Picaso.Leonardo@gmail.com)'s article

Quote:

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

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