Article - CS324431

Enable row compression on all indexes in SQL Server for Windchill

Modified: 05-Nov-2024   


Applies To

  • Windchill PDMLink 10.1 to 13.0
  • SQL Server 2012, 2014, 2016, 2017, 2019
  • Enterprise Edition is required for versions prior to SQL Server 2016 SP1
  • Azure SQL

Description

  • By default indexes are not compressed in a Windchill database
  • Index compression can reduce disk space
  • This can also improve performance as the buffer pool memory usage is reduced
This is a printer-friendly version of Article 324431 and may be out of date. For the latest version click CS324431