I have a database of 1.5 TB, which had only 200 GB free space before.Due to performance issues, business decided to reduce 1 month data retention policy to 1 week.Due to this 3 weeks data was deleted and now it has 700 GB free space.
The 500 GB free space increased due to data delete is no more required, and there no chance to grow data again to occupy this 500 GB space.
I am planning to shrink the database(using shrink file command ) and run index optimization process to rebuild indexes, if fragmentation is greater than 30%. The released space wont be used by other systems, however can be used for log file and temp db growth efficiently in near future.
Is there any benefits on performance by reducing the size of database, other than space release ?
Previous questions related to shrinking(in stack exchange) does not properly answer to my queries.
Thanks in advance for your kind reply !!!