grahamc/hydra2 - Change KDBWLKRPZS2XQNS4IXBYJGRZ7OO7OQSC2MRUQDTY2M55G55CTQRAC

This significantly speeds up deleting Builds, since it removes the need for a sequential scan on BuildSteps.

Created by Eelco Dolstra on July 8, 2015

KDBWLKRPZS2XQNS4IXBYJGRZ7OO7OQSC2MRUQDTY2M55G55CTQRAC

main

[2.133]

[3.20632]

create index IndexBuildStepsOnPropagatedFrom on BuildSteps(propagatedFrom) where propagatedFrom is not null;

[5.3004]

create index IndexBuildStepsOnPropagatedFrom on BuildSteps(propagatedFrom) where propagatedFrom is not null;