• trayalacheruvu (7/28/2009)


    Hi,

    is there any performance issue by Shrinking the DB.Please update your inputs here.

    Thanks,

    Thulasi.

    Yes, you'll face performance issues. This is due to the fact that shrinking causes fragmentation of indexes. You may have to reorganze or rebuild your indexes post shrink operation.

    If you're certain that your database will not reach it's current size in next 3-6 months, you can do shrinking for once or else leave it to its current size as it'll be eventually filled in due course of time.



    Pradeep Singh