If you want table to be created automatically why not create a job in sql server agent which will call a t-sql stored procedure to populate the PoleReport table based on your schedule. Then you can add the required indexes after population to speed up the queries. For daily loads drop indexes first, do data load and recreate indexes again if data volume is huge.
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c
No comments:
Post a Comment