Post reply

When does "create index" execute

  • September 6, 2006 at 9:18 am

    #113504

    The way I understand it "Create Index" is part of the data definition language and as such if ran against a table it executes or creates the index immediately. I've been asked if this is true and to find docs backing it up as there may be a need for us to create an index on an existing table that contains millions of records in a production database. Does anyone 1.) know for sure that in fact it does execute immediately and in the foreground 2.) know of any docs that specifically state when create index or other ddl query's execute.

  • September 6, 2006 at 10:23 am

    #658797

    Unless you schedule the job to create index it will start creating and will have locks on the table.

    Thanks

    Sreejith

  • September 6, 2006 at 10:24 am

    #658798

    Thank you for your response. I just wanted to verify.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply