I have a table with about 200,000 records. so last week i decided to reduce the size to optimize performance so i backed up the table using
after few days, i needed to restore data that has been deleted, so i renamed the tables
select *into table_1 from table
table_1 to table
table to table_1
then did a query to insert the the newly added records and consolidate both tables
Now that was all fine, but im just wondering if this would cause any indexing issues or corruptions. as i started to experiance performance and speed issues lately. i made sure there was no duplicates and ran
insert into table (a,b,c) select a,b,c from table_1 where datecreated > '02/08/2012'
dbcc checktable ("products");
any suggestions ??