How is it query performance assessedSolution In order to enh

How is it query performance. assessed?

Solution

In order to enhance the query performance we should choose a method calledindexing which will be very helpful. This technique reduces the i/0 rates as well as improve the usage of system resources.

For the better usage of indexing,we should know how the data is going to be used, as well as the different kinds of queries that are going to run and also their corresponding occurances or frequencies finally it depends on the query processor that how it is going to use indexes inorder to get the data in a faster way.

After successful completion of what indexes are to be created then analyze the queries, as well as the performance which the user is expecting more in most of the times. Then try to maintain coresponding indexes to those queries.Then adding an index, once again run the query and check the performance.if improved then maintain else reomve it.