Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
evaluate the times it took for the system to process the insertion of the records, and determine which type of insert ran the fastest (with or without index) and why. As part of this, advise on your recommended approach. This should be evaluated from a performance perspective solely for inserting data.

evaluate the times it took for the system to process the insertion of the records, and determine which type of insert ran the fastest (with or without index) and why. As part of this, advise on your recommended approach. This should be evaluated from a performance perspective solely for inserting data.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

 In 250-500 words evaluate the times it took for the system to process the insertion of the records, and determine which type of insert ran the fastest (with or without index) and why. As part of this, advise on your recommended approach. This should be evaluated from a performance perspective solely for inserting data.

8. CONNECTIONS ✓ SERVERS AZURE localhost, <default> (sa) Databases System Databases AShahbain dbo guest sys Built-in Schemas INFORMATION_SCHEMA Programmability 53 YOU External Resources Service Broker Storage Security Security Logins Server Roles Credentials Cryptographic Providers Audits Server Audit Specifications Server Objects Module_3_Insert2.sql - localhost.AShahbain (sa) hahbain SQLQuery_1 - localh...in (sa) Users > asalahshahbain > Downloads > Module_3_Insert2.sql ▷ Run Cancel Disconnect Change Database: AShahbain Enable Actual Plan✓ ParseEnable SQLCMD: To Notebook 87 88 89 90 91 92 93 94 95 96 Messages 4:16:20 PM 4:16:20 PM select 601580, 'Linus', 'Young', '11/22/2018', 'English',982,778 UNION ALL select 601581, 'Thaddeus', 'Morrow', '03/23/2019', 'Education', 1931,2268 UNION ALL select 601582, 'Fitzgerald', 'Gay', '03/31/2018', 'History', 1961, 8441 UNION ALL select 601583, 'Jael', 'Roth', '02/20/2019', 'Public Health', 1414, 5684 UNION ALL select 601584, 'Zephania', 'Freeman', '10/02/2018', 'History',503,9433 UNION ALL select 601585, 'Zena', 'Dominguez', '07/30/2017', 'Theater', 1237,8150 UNION ALL select 601586, 'Gil', 'Hancock', '03/18/2018', 'CyberSecurity', 15, 8210 UNION ALL select 601587, 'Linus', 'Raymond', '12/30/2018', 'Policy', 1314, 2221 UNION ALL select 601588, 'Reagan', 'Ayala', '04/20/2019', 'Informatics', 674,631 UNION ALL select 601589, 'Jelani', 'Hawkins', '10/15/2018', 'DataAnalysis',364,5858 UNION ALL 4:16:20 PM 4:16:20 PM 4:16:20 PM 4:16:20 PM Module_3_Insert2.sql - localh...in (sa) X Started executing query at Line 1 Msg 207, Level 16, State 1, Line 6 Invalid column name 'ID'. Started executing query at Line 5008 Msg 207, Level 16, State 1, Line 5008 Invalid column name 'ID'. Started executing_query at Line 10010 Msg 207, Level 16, State 1, Line 10010 Invalid column name 'ID'. Started executing query at Line 15012 Msg 207, Level 16, State 1, Line 15012 Invalid column name 'ID'. Started executing query at Line 20014 Msg 207, Level 16, State 1, Line 20014 Invalid column name 'ID'. Estimated Plan Started executing query at Line 25016 Msg 207, Level 16, State 1, Line 25016 Invalid column name 'ID'. Total execution time: 00:00:06.224 00 369
Transcribed Image Text:8. CONNECTIONS ✓ SERVERS AZURE localhost, <default> (sa) Databases System Databases AShahbain dbo guest sys Built-in Schemas INFORMATION_SCHEMA Programmability 53 YOU External Resources Service Broker Storage Security Security Logins Server Roles Credentials Cryptographic Providers Audits Server Audit Specifications Server Objects Module_3_Insert2.sql - localhost.AShahbain (sa) hahbain SQLQuery_1 - localh...in (sa) Users > asalahshahbain > Downloads > Module_3_Insert2.sql ▷ Run Cancel Disconnect Change Database: AShahbain Enable Actual Plan✓ ParseEnable SQLCMD: To Notebook 87 88 89 90 91 92 93 94 95 96 Messages 4:16:20 PM 4:16:20 PM select 601580, 'Linus', 'Young', '11/22/2018', 'English',982,778 UNION ALL select 601581, 'Thaddeus', 'Morrow', '03/23/2019', 'Education', 1931,2268 UNION ALL select 601582, 'Fitzgerald', 'Gay', '03/31/2018', 'History', 1961, 8441 UNION ALL select 601583, 'Jael', 'Roth', '02/20/2019', 'Public Health', 1414, 5684 UNION ALL select 601584, 'Zephania', 'Freeman', '10/02/2018', 'History',503,9433 UNION ALL select 601585, 'Zena', 'Dominguez', '07/30/2017', 'Theater', 1237,8150 UNION ALL select 601586, 'Gil', 'Hancock', '03/18/2018', 'CyberSecurity', 15, 8210 UNION ALL select 601587, 'Linus', 'Raymond', '12/30/2018', 'Policy', 1314, 2221 UNION ALL select 601588, 'Reagan', 'Ayala', '04/20/2019', 'Informatics', 674,631 UNION ALL select 601589, 'Jelani', 'Hawkins', '10/15/2018', 'DataAnalysis',364,5858 UNION ALL 4:16:20 PM 4:16:20 PM 4:16:20 PM 4:16:20 PM Module_3_Insert2.sql - localh...in (sa) X Started executing query at Line 1 Msg 207, Level 16, State 1, Line 6 Invalid column name 'ID'. Started executing query at Line 5008 Msg 207, Level 16, State 1, Line 5008 Invalid column name 'ID'. Started executing_query at Line 10010 Msg 207, Level 16, State 1, Line 10010 Invalid column name 'ID'. Started executing query at Line 15012 Msg 207, Level 16, State 1, Line 15012 Invalid column name 'ID'. Started executing query at Line 20014 Msg 207, Level 16, State 1, Line 20014 Invalid column name 'ID'. Estimated Plan Started executing query at Line 25016 Msg 207, Level 16, State 1, Line 25016 Invalid column name 'ID'. Total execution time: 00:00:06.224 00 369
Para e 'A mic dye ou c le to udic We ens ● Q 0 0 4 2 9 CONNECTIONS ✓ SERVERS > > AZURE 20% @ localhost, <default> (sa) Databases System Databases AShahbain Security Logins Server Roles > Credentials > Cryptographic Providers > > ... YOU Audits Server Audit Specifications Server Objects bain 372 Module_3_Insert1 (1).sql - localhost.AShahbain (sa) SQLQuery_1 - localh...in (sa) Users > asalahshahbain > Downloads > Module_3_Insert1 (1).sql ▷ Run Cancel Disconnect Change Database: AShahbain Enable Actual Plan ParseEnable SQLCMD: To Notebook elect 606605, 'Baxter', 'Hoover', '10/23/2017', 'ComputerScience', 124,6231 UNION ALL elect 606606, 'Hadley', 'Montgomery', '10/26/2017', 'CyberSecurity',105,5981 UNION A elect 606607, 'Laurel', 'Herman', '11/09/2018', 'DataAnalysis', 541,8941 UNION ALL elect 606608, 'Merrill', 'Bray', '09/30/2018', 'Physics', 1358,7791 UNION ALL elect 606609, 'Tanisha', 'Farrell', '02/05/2019', 'Statistics', 1176,6067 UNION ALL elect 606610, 'Jocelyn', 'Barnett', '05/19/2018', 'Statistics', 117,6 UNION ALL elect 606611, 'Wayne', 'Dickson', '11/17/2018', 'Statistics',772,5714 UNION ALL elect 606612, 'Grace', 'Hampton', '09/14/2017', 'Theater', 229,8813 UNION ALL elect 606613, 'Sebastian', 'Frazier', '11/17/2017', 'Policy', 71,6834 UNION ALL elect 606614, 'Rhea', 'Davenport', '07/06/2017', 'Statistics', 1057,4566 UNION ALL 5112 5113 5114 5115 5116 5117 5118 5119 5120 5121 Messages 5:38:00 PM 5:38:00 PM 5:38:00 PM 5:38:00 PM 5:38:00 PM 5:38:00 PM Started executing_query at Line 1 (0 rows affected) Module_3_Insert1 (1).sql - localh...in (sa) X (5000 rows affected) Started executing query at Line 5006 (5000 rows affected) Started executing query at Line 10008 (5000 rows affected) Started executing query at Line 15010 (5000 rows affected) Started executing query at Line 20012 (5000 rows affected) Started executing query at Line 25014 (3500 rows affected) Total execution time: 00:04:56.358 10 08 Estimated Plan ... F
Transcribed Image Text:Para e 'A mic dye ou c le to udic We ens ● Q 0 0 4 2 9 CONNECTIONS ✓ SERVERS > > AZURE 20% @ localhost, <default> (sa) Databases System Databases AShahbain Security Logins Server Roles > Credentials > Cryptographic Providers > > ... YOU Audits Server Audit Specifications Server Objects bain 372 Module_3_Insert1 (1).sql - localhost.AShahbain (sa) SQLQuery_1 - localh...in (sa) Users > asalahshahbain > Downloads > Module_3_Insert1 (1).sql ▷ Run Cancel Disconnect Change Database: AShahbain Enable Actual Plan ParseEnable SQLCMD: To Notebook elect 606605, 'Baxter', 'Hoover', '10/23/2017', 'ComputerScience', 124,6231 UNION ALL elect 606606, 'Hadley', 'Montgomery', '10/26/2017', 'CyberSecurity',105,5981 UNION A elect 606607, 'Laurel', 'Herman', '11/09/2018', 'DataAnalysis', 541,8941 UNION ALL elect 606608, 'Merrill', 'Bray', '09/30/2018', 'Physics', 1358,7791 UNION ALL elect 606609, 'Tanisha', 'Farrell', '02/05/2019', 'Statistics', 1176,6067 UNION ALL elect 606610, 'Jocelyn', 'Barnett', '05/19/2018', 'Statistics', 117,6 UNION ALL elect 606611, 'Wayne', 'Dickson', '11/17/2018', 'Statistics',772,5714 UNION ALL elect 606612, 'Grace', 'Hampton', '09/14/2017', 'Theater', 229,8813 UNION ALL elect 606613, 'Sebastian', 'Frazier', '11/17/2017', 'Policy', 71,6834 UNION ALL elect 606614, 'Rhea', 'Davenport', '07/06/2017', 'Statistics', 1057,4566 UNION ALL 5112 5113 5114 5115 5116 5117 5118 5119 5120 5121 Messages 5:38:00 PM 5:38:00 PM 5:38:00 PM 5:38:00 PM 5:38:00 PM 5:38:00 PM Started executing_query at Line 1 (0 rows affected) Module_3_Insert1 (1).sql - localh...in (sa) X (5000 rows affected) Started executing query at Line 5006 (5000 rows affected) Started executing query at Line 10008 (5000 rows affected) Started executing query at Line 15010 (5000 rows affected) Started executing query at Line 20012 (5000 rows affected) Started executing query at Line 25014 (3500 rows affected) Total execution time: 00:04:56.358 10 08 Estimated Plan ... F
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS