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.