Return
-
Title
Change Tracking does not show a create date and time for index or clustered index -
Description
In PASS 6.5 change tracking, the table, constraint, and clustered index were create at the same time, but only table and constraint shows create time/date.
-
Resolution
This is because SQL Server is not consistent in the way it shows creation timestamp for a new Index. Since PA cannâ€t retrieve the accurate creation date for the Index from SQL Server catalog, PA will show the first time that this index was discovered by the change tracking, as the creation timestamp.