Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Partitioning Database problems

    I am partitioning my database based on a Number.

    For Loading Data in Member Tables
    I used "select * into memtable from basetable where basetable.Number= 1"

    After that i have added constraints ,indexes on the memtable

    But the space occupied by indexes in the memtable is at least 3 times the indexes size on base table

    Could ne body help me on this??

    Thanks in Advance

  2. #2
    Join Date
    Feb 2004
    Posts
    492

    Re: Partitioning Database problems

    Do both tables have clustered indexes and are they on the same columns?

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Re: Partitioning Database problems

    Yeah, The clustered indexes are on the same columns

Posting Permissions

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