How can you make sure that the proper indexes have been put

Assignment Help Computer Engineering

Reference no: EM131164370

MAIL-ORDER INDEX

A Virginia-based mail-order company sends out approximately 25 million catalogs each year, using a customer table with 10 million names. Although the primary key of the customer table is customer identification number, the table also contains an index of customer last names. Most people who call to place orders remember their last name, but not their customer identification number, so this index is used frequently. An employee of the company explained that indexes are critical to reasonable response times. A fairly complicated query was written to locate customers by the state in which they lived, and it took over three weeks to return an answer. A customer state index was created, and that same query provided a response in 20 minutes; that's 1512 times faster!

QUESTION:

As an analyst, how can you make sure that the proper indexes have been put in place so that users are not waiting for weeks to receive the answers to their questions?

Reference no: EM131164370

Questions Cloud

What different kinds of data will the system use : Does it have characteristics of more than one? What different kinds of data will this system use? On the basis of your answers, what kind of data storage format(s) do you recommend for this system?

Evaluate the plans of at least two peers : Build a plan for evaluating the job description you created in Week Two. Share the plan in the exercise area. Evaluate the plans of at least two peers, citing at least two scholarly sources including the course text.

How would you denormalize the physical data model : DENORMALIZING A STUDENT ACTIVITY FILE. How would you denormalize the physical data model, and what are the benefits of your changes?

Point of highest pressure and lower pressure : The maximum velocity of the flow past a circular cylinder, as shown, is twice the approach velocity. What is ?p between the point of highest pressure and the point of lowest pressure in a 40 m/s wind? Assume irrotational flow and standard atmosphe..

How can you make sure that the proper indexes have been put : As an analyst, how can you make sure that the proper indexes have been put in place so that users are not waiting for weeks to receive the answers to their questions?

Calculate the expected return on stock : Suppose you observe the following situation: a. Calculate the expected return on each stock.

What is the most popular kind of database today : What is the most popular kind of database today? Provide three examples of products that are based on this technology.

Determine type of data storage format that should be adopted : What are the two most important factors in determining the type of data storage format that should be adopted for a system? Why are these factors so important?

Relevance of emotional intelligence in project leadership : You are an office manager who has recently moved into a new department. It comes to your attention that there is a member of senior management who has been falsifying expense reports for himself and approving falsified reports for his subordinates..

User Account

All Pages