Measures to improve performance of database tables

Asked By 10 points N/A Posted on -
qa-featured

Is it possible for a database admin to steal your customer’s passwords? How can you prevent this from happening? What are the things that you can do to speed up the processing of your database and remove performance issues? Explain the different ways in which performance tuning can be achieved with respect to a database. 

SHARE
Answered By 0 points N/A #200089

Measures to improve performance of database tables

qa-featured

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.

Login/Register to Answer

Related Questions