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