All Forums Database
dan.lorenc 1 post Joined 03/16
11 Mar 2016
Splitting a table?

Given: a large table; 14/50 fields responsible by one group; the rest by a second group; the need to for 5/14 fields to be used by analysts familar with the large table (ie. large numbers of scripts written against the current large table; business hour performance on this large table is a primary concern. Updates are typically schedule after hours.
Objective: allow the update of the 14 fields to be done during business hours.
Current recommendation: split the 14 fields and data into a seperate table, provide admin rights to the second group, create an evening backfeed process to update the results of the 5 fields back into the current large table.
Other solutions?
 
Thank you for the help!

Dan Lorenc
You must sign in to leave a comment.