300 million rows in a table RRS feed

  • Question

  • Hello Gurus,

    I have a table with over 300 million records in it. I was wondering if you can give me some ideas on how to ensure performance of the database is optimum. What is generally advised?

    1- Can I do partition of this table that is already holding that many records?

    2- How about any special indexing tips?

    It would be great if you can send me some links from where I can get detailed ideas.

    Thanks in advance,


    Thursday, September 12, 2013 2:23 PM


All replies