motioneye
asked on
sql2008, index on table that get truncated always
Guys,
I have a table that get truncated always it usually has around 50k - 200k of rows, this table somehow are heavily reference by our query, so if I create an index on this table will it improve the overall query performance ? despite of data always get truncated and loaded with new data will it impact any pages inside this table here?
I have a table that get truncated always it usually has around 50k - 200k of rows, this table somehow are heavily reference by our query, so if I create an index on this table will it improve the overall query performance ? despite of data always get truncated and loaded with new data will it impact any pages inside this table here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
do you still have questions on this?