Measures to improve performance of database tables

Asked By Azreil Balthazar 10 points N/A Posted on - 11/18/2014

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. 

• Status: Open
• Question Views: 497
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Tanthle Yak 0 points N/A #200089

Measures to improve performance of database tables

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.

About Tanthle Yak

Questions
0

Answers
100

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 12/26/2014
• Question Category: Database