● ●Steve Jobs Quotes About Life,Design and Apple ●Quality is more important than quantity. One home run is much better than two doubles ● Do you want to spend the rest of your life selling sugared water or do you want a chance to change the world? ●Almost everything--all external expectations, all pride, all fear of embarrassment or failure--these things just fall away in the face of death, leaving only what is truly important. Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose. You are already naked. There is no reason not to follow your heart.●

Search This Blog

Query Optimization?

Question : What is query Optimization?
Ans:-Queries of a database can be fast or slow. Depends on a lot of things. The size of the table, the amount of data you are requesting from the query, etc.
One of the ways a dba can help query optimization, is by "updating statistics" on a table. Statistics of a table allows the query to find the most efficient way to gather the data from the table.
Posted by

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)