associate72
Technical User
Please help.
1) What would be the most efficient way (command/code) to move records which are older than 9 months from Table A to Table B on a regular basis?
2) Does indexing tables on a regular basis during off-peak hours improve overall performance? And if so, how would I go about scheduling this to occur?
I appreciate any help/ insight to my questions.
Thanks in advance.
1) What would be the most efficient way (command/code) to move records which are older than 9 months from Table A to Table B on a regular basis?
2) Does indexing tables on a regular basis during off-peak hours improve overall performance? And if so, how would I go about scheduling this to occur?
I appreciate any help/ insight to my questions.
Thanks in advance.