I've compsite index on three fields that's NErrorCode, TmeRun and DteRun inside a table with title as AURORATASKS_STATUS getting index position 1, 2, 3 repectively. Now i wish to alter the position of DteRun to at least one. The way i will write a SQL statement with this?
Drop the present index, and make up a brand new one.
Standard SQL for shedding a catalog is
DROP INDEX indexname;
And adding a replacement
CREATE INDEX indexname ON tablename (DteRun, NErrorCode, TmeRun);
CREATE INDEX indexname ON tablename (DteRun, TmeRun, NErrorCode);
Most contemporary dbms possess a relatively many choices for creating indexes. It's most likely worth reading through about the subject before you decide to do this.