Ignore ASYNC and build indexes synchronously based on config property

At test time, we want to ignore the ASYNC keyword on CREATE INDEX and instead just build the index synchronously. We can control this through a config parameter defaulted to true at test time and false otherwise.