Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    50

    Unanswered: alter PCTFREE on index

    Hi

    I can specify a PCTFREE value on an index in the CREATE INDEX statement. (UDB 8.1 Unix/Windows)

    How can I change the PCTFREE value without dropping and creating the index ?

    Marc

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Marc,
    There is no ALTER INDEX statement, so I do not think it can be changed without dropping and recreating it.

    Andy

Posting Permissions

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