Thread: Adding PK using INDEX is taking time

Adding PK using INDEX is taking time

From
Laszlo Fogas
Date:
hello guys, 

anyone experienced that 

ADD CONSTRAINT xx PRIMARY KEY USING INDEX 

is not returning immediately? 

I'm pointing it to a nice UNIQUE index, it has all locks acquired, but reads the disk heavily. Then i killed it, since queries started to pile up.

--
Laszlo