Results 1 to 4 of 4

Thread: Index creation

  1. #1
    Join Date
    Apr 2007
    Posts
    26

    Unanswered: Index creation

    Hi guys, Is it possible to create an index of a table to a different location from the table space? If it is how do i do it in windows?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It depends on the type of tablespace the table is in. If it is a SMS tablespace, then, no you cannot. If it is DMS then yes you can.

    Andy

  3. #3
    Join Date
    Apr 2007
    Posts
    26
    Whats the code for DMS tablespace?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Check out the documentation:

    http://publib.boulder.ibm.com/infoce...n/r0000929.htm

    This is for V8

    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
  •