We divided our tables from table zone_a, ..._b, ..._c to zone_z, these
tables have the same attributes. We have divided this tables in this way
so that any data that is under zone_a would only be on it's specific
table, and the same with the other remaining table. Since per table
holds thousands of data per day we have decided it to be designed this
way and also hoping to reduce lock up of tables everytime a user
accesses the table.
Now, we made a function that returns a table. This function will handle
what table is to be selected. The body of this function contains a table
variable, it holds the data from the selected table. This function will
return the table variable
We have made this function hoping that it would be efficient to use for
other future procedures.
Is it efficient?
Thank You in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!