What strategies can be used to write queries that run more efficiently?
What will be an ideal response?
It makes sense to specify the attribute names rather than just * in the SELECT clause. If you are writing a query for a wide table, specifying only the attributes that are needed is going to save a great deal of processing time. Also, changes in the base table post-production could affect query results. Specifying the attribute names will make it easier to notice and correct for such errors.
Use subqueries sparingly, since these increase processing time.
If you have several separate reports which need data from one table, write one query to retrieve all of the data and use what you need in each report.
You might also like to view...
When gathering marketing intelligence, companies often use the US census, which provides an in-depth look at the population swings, demographic groups, regional migrations, and changing family structure of the more than 281 million people living in
the United States. Which of the following steps to improve the quality of a company marketing intelligence system would be most closely associated with this illustration? A) A company can purchase information from outside suppliers. B) A company can take advantage of government data sources. C) A company can use online customer feedback systems to collect data. D) A company can network externally. E) A company can use its sales force to collect and report data.
In the Kellogg's example given in your text, as a result of problem-solving research, Kellogg's found out that it was not being creative in introducing new products to meet the needs of the adult market
Indicate whether the statement is true or false