DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: non unique index on a partinion table

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    Can i create a non-unique index on a partiton table ?

    I have a partition table with 16B data and 365 partitions.
    Can i create a global non unque index for this table

    thanks in advance
    tom

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    I don't see why not. Wait for someone to confirm this, since we do not use partitions in our environment.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, that is no problem.
    Jeff Hunter

Posting Permissions

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


Click Here to Expand Forum to Full Width