Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2017
    Posts
    3

    Unanswered: need to create index on existing table having huge volume

    Hi Guys,

    can i create, will be there any issue

    need to create index on existing table having huge volume

    Thanks in advance

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    Yes there may well be impacts, on concurrency during the build, on dynamic-SQL, or repopt-always packages, on disk-space usage, other performance objects that exist on the table concerned, the nature of the index and table, the nature of the workload, the timing, . As you give no relevant facts in your question you can only get a generic answer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •