Why We Need Database Optimization

Before we start with the Database optimization, first understand the need of database Optimization in our Application which explain through the following Example.

Example

In XYZ Company there was Lots of file, but the file were not arranged in any order in the File Drawer. So, each time a person asked for a File to the Assistance, the Assistance had no way but to check every file to find the required file that the person wanted. Finding the desired file used to take around 5 to 10 minutes for the Assistance. After some days Manager was give idea to Assistance for providing File Number to each file, so that idea help to the Assistance to find the specific file within seconds. Same above concept we used in our database through database Optimizing.

What is Database Optimization

Before we start the concept of database Optimization, understand the dictionary meaning Of Optimization Means “allow us to achieve the best possible performance in the quickest amount of time”. if we don’t do all our database operations in optimized way so, It will be almost impossible to handle or access large amount of data for our applicatons. When a database based application performs slowly, there is a Most probability that, the data access routines( Query and Techniques ) of that application are not optimized or not written in the best possible way. so further we given some points to overcome form this problem.

Role of Database Optimization in Database Management

As a team member I shared this information, so you considered all points before Design the database.

• First thing matter in database table is primary key,which allow us to identify unique records From thousands of records.


• Through primary key, Database server find out the particular records within the seconds. So Always make table with primary key is best practice for optimizing application.


• If your application deals with thousands of records, then utilized the Database Optimization techniques. It will provide better performance in your Application.


• Optimization techniques allowed to Database server to arrange the table data according to serial number, through which it will first find out the serial number of desired data, after that it will directly point to the physical table record without scanning of entire Database table.