1. The following tables exist in a database.  The first table is used
to register customers within the system while the second table records
customer orders.  Currently, the database contains 1.5 million
customer entries with at least one order per customer.  Company
representatives often look up customer orders based on the customer?s
account number.  There are numerous complaints that as the number of
users on the system increases customer order searches begin to time
out.  You are called in to investigate.  What is your course of
action?


create table customer
(
	customerid int identity,	-- unique customer id
	fname	varchar(50),		-- customer first name	
	lname	varchar(50),		-- customer last name
	accountnum	varchar(11)	-- account number
);



create table customerorder
(
	orderid	int identity, -- unique order id
	customerid 	int,          -- foreign key from customer table
	orderdate	datetime      -- date the order was placed
);

---

Request for Question Clarification by scriptor-ga on 05 Mar 2006 12:53 PST

Google Answers discourages and may remove questions that are homework
or exam assignments.

Scriptor

---

Clarification of Question by tanujaravi-ga on 05 Mar 2006 13:07 PST

this is not an assignment question or home work

What you can do is split the database according to commodities, i.e.
group some number of items and have seperate database for each group.
This will reduce number of customer in each database.

Could u try creating an index on accountnum column in customer table.
Since your searches are based on the account number, it should speed
up the queries.