Create an index on the CustomerID column of the Customer_T and Order_T table in Figure 4-4.
Figure 4-4


Transcribed Image Text:
A
CustomerID
4
A
+
+
G
+
+
14
+
f
Record: H
E
16:0
A
OrderID
#
3
Record: 14
Customer_T
CustomerName
1 Contemporary Casuals
2 Value Furniture
3 Home Furnishings
4 Eastern Furniture
5 Impressions
6 Furniture Gallery
CustomerAddress
1355 S Hines Blvd
15145 S.W. 17th St.
1900 Allard Ave.
1925 Beltline Rd.
5585 Westcott Ct.
325 Flatiron Dr.
394 Rainbow Dr.
816 Peach Rd.
7 Period Furniture
8 California Classics
9 M and H Casual Furniture
37
EE
10 Seminole Interiors
24
11 American Euro Lifestyles 24
OrderID
12 Battle Creek Furniture
34
1001
13 Heritage Furnishings
66
14 Kaneohe Homes
11
15 Mountain Scenes
41
No Filter Search
of 15 ▸
Order T
OrderDate CustomerlD.
7
1001 10/21/2018
1002 10/21/2018
1003 10/22/2018
1004 10/22/2018
1005 10/24/2018
1006 10/24/2018
1007 10/27/2018
1008 10/30/2018
1009
1010
11/5/2018
11/5/2018
NA
1 of 10
18553 N
2
11
12
4
1
No Filter S
Record: 14
1001
1001
1002
1003
1004
1004
1005
1006
1006
006
1007
1007
1008
1008
1009
1009
1010
CustomerCit CustomerStat
Gainesville FL
Plano
TX
NY
Albany
Carteret
NJ
Sacramento
CA
CO
Boulder
Seattle
WA
Santa Clara
CA
OrderLine T
Ordered Quantity
ProductID
1 of 18
▸
M
1
2
4
3
3
6
8
4
4
5
7
1
2
3
8
4
7
8
No Filter
2
21
5
3
2
AN
4
1
~23~ MM ~3
3
3
2
10
Search
CustomerPostalCod
32601-2871
75094-7743
12209-1125
07008-3188
94206-4056
80514-4432
97954-5589
96915-7754
120-2314
46-4423
08-5621
15-3401
13-8834
44-2537
03-4432