Re: Changing column's sequence in index
Posted by:
Rick James
Date: December 31, 2009 01:50AM
Assuming you have INDEX `ab` (`a`,`b`) on table `tbl`:
ALTER TABLE tbl
DROP INDEX ab,
ADD INDEX (b,a);
I am assuming you mean the order of a and b, when you say 'sequence'; not the SEQUENCE found in Oracle.
Subject
Views
Written By
Posted
5879
December 29, 2009 11:27PM
Re: Changing column's sequence in index
2550
December 31, 2009 01:50AM
2386
December 31, 2009 02:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.