Cancel
Showing results for 
Search instead for 
Did you mean: 

Rebuild indexes in TC8.3

Experimenter
Experimenter

I know in TC 10.1, Index_verifier will give you the commands to rebuild/defragment the indexes that are fragmented. If you run the same command in TC8.3, it doesn't give you the command to rebuild the indexes. Is there a command to run that will do this?

3 REPLIES

Re: Rebuild indexes in TC8.3

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

No, there is none for Tc previous to 10.1, for these you need to use the regular SQL commands.

 

There is a script to defragment available on the net on MSDN (Microsoft Software Developers Network).

Stefan Pendl, Systemmanager CAx, HAIDLMAIR GmbH
Production: NX10.0.3, VERICUT 8.1, FBM, MRL 3.1.7 | TcUA 10.1 MP7 Patch 0 (10.1.7.0) | TcVis 11.4
Development: C (ITK), .NET, Tcl/Tk Testing: NX12.0 | AWC 3.4 Preparing: NX12.0

Employees of the customers, together we are strong Smiley Wink
How to Get the Most from Your Signature in the Community
NX Customization - Best Practice Guide

Re: Rebuild indexes in TC8.3

Experimenter
Experimenter

Thanks. I haven't found any scripts that will defrag the indexes in all of the tables. Do you happen to have a link handy for the script?

Re: Rebuild indexes in TC8.3

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

See sys.dm_db_index_physical_stats (Transact-SQL) section D for a way to defragment all indexes of a database.

Stefan Pendl, Systemmanager CAx, HAIDLMAIR GmbH
Production: NX10.0.3, VERICUT 8.1, FBM, MRL 3.1.7 | TcUA 10.1 MP7 Patch 0 (10.1.7.0) | TcVis 11.4
Development: C (ITK), .NET, Tcl/Tk Testing: NX12.0 | AWC 3.4 Preparing: NX12.0

Employees of the customers, together we are strong Smiley Wink
How to Get the Most from Your Signature in the Community
NX Customization - Best Practice Guide