Measures to improve performance of database tables
Asked By
10 points
N/A
Posted on - 11/18/2014
Yes, database administrators may hack the user’s passwords. To prevent this, the administrator's data should be daily reviewed by some data analysts and keep track of data. To increase the performance of databases, few things have to be taken care of. Firstly, optimize the logical design, physical design and maintenance. We should utilize an appropriate indexing strategy for eliminating unused indexes. We should also check windows power plan settings and use distinct disks for storing data files, log files and all the database backup related files.