How do you optimize database?

devquora

devquora

Posted On: Feb 22, 2018

To fine-tune the performance and optimize the database, execute the following steps.

Use Indexing - Index is a data structure that increases the speed of the data retrieval operations.
Execution plans - Execution plan tool in the SQL server is useful in creating indexes.
Avoid coding loops - When possible avoid the loops in your code to increase the performance of the database.
Avoid correlated SQL subqueries - A correlated subquery gets values from the parent query. It decreases the performance of the database operations. So try to avoid it. Finally, Use or avoid temporary tables according to your specific requirements.

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related Questions

What is iNode on Linux and more details on that?

The iNode in Linux is an entry table containing information about the regular file and directory. It can be viewed as a data structure that contains the metadata about the files. The following are the...

How do you check physical memory on Linux?

There are a number of ways to check for physical memory size on Linux. The popular ways are, Free command: Type the free command to check the physical memory size. free -b //gives the size in bytes ...

How do you copy a local file to HDFS?

The fs put command is used to copy or upload a file from the local filesystem to the specific HDFS. Syntax fs put --from source_path_and_file --to dest_path_and_file ...