Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    61

    Unanswered: Index File growing big

    Hi all

    I have a DB with 1 data file, 1 log file and 1 index file.
    data file is 3 GB but index file is 12 GB.
    Index file is growing big day by day.
    This cause performance of DB down.
    What should I do to prevent index file become bigger and size of index file smaller?

    Thanks in advanced
    Thi Nguyen

  2. #2
    Join Date
    Jul 2004
    Posts
    61
    help me.

    Thi Nguyen

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Do you have ANY index maintenance tasks implemented?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Jul 2004
    Posts
    61
    Hi rdjabarov
    What do you mean "ANY index maintenance tasks" ?
    I have many indexes in DB.

    Thi Nguyen

  5. #5
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137
    do u mean transaction log file as index file...?
    Sudar

    --
    My Blog

  6. #6
    Join Date
    Jul 2004
    Posts
    61
    I meant that index file growing big, not transaction log.
    Thanks

Posting Permissions

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