Suoritettu

Database my sql -- 4

it's very small project but i don't have time.

You will be using MySQL to obtain query execution plans and profile queries to explore the benefit of indexes. MySQL provides the command “explain’ to obtain the execution plan of queries. We will be looking at the query execution plan to learn if indexes are used to execute the query.

To view a query execution plan, you must prefix it with “Explain” command.

From this table, you can know if an index is used to execute the query.

Additionally, you will be using the command “show profiles” to obtain the query actual runtime (make sure to enable profiling in advance, see the Prerequisites Section.)

Prerequisites

1. Install MySQL.

2. Create two tables: Students and Courses as follows:

create table Student (sid int, sname varchar(100));

create table Course (cid int, cname varchar(100));

3. Enable profiling by executing “set profiling = 1;”

Inserting Data

In this lab, you will evaluate queries with 1,000 and 1,000,000 data entries. First, populate Students and Courses tables with 1,000 rows for each table. sid and cid are sequence numbers —i.e., 1 for the first row, 2 for the second row and so forth. sname and cname may be populated with random data.

For the second task of the assignment (see below), you will be inserting 1,000,000 rows for each table instead of 1,000.

Tasks

Below, you are given a set of queries to evaluate and enhance their performance with 1,000 and 1,000,000 rows.

1. With 1,000 Rows

For each query, report its execution plan and runtime without any indexes to be your baseline. Next, add at least one index that should be beneficial for each query to enhance its performance. Your list of possible indexes must include - but not limited to - hash, B-tree and composite indexes.

For each step, include the query execution plan and profiled duration in your report by taking screenshots. They should be your guideline whether your added index is beneficial or not. Additionally, you must write your explanation and justification for each step. (explain why you think an index is useful/not useful)

2. With 1,000,000 Rows

Repeat task 1 after inserting 1,000,000 rows for each table instead of 1,000.

Queries

1. Select * From Students where sid=5;

2. Select * From Students where sname like ‘%s%’;

3. Select * From Students where sid >5 and sid < 100

4. Select * From Students;

5. Select * From Students where sid=5 and sname=’Ahmad’

6. Select * From Students, Courses where sid=cid

Taidot: SQL, MySQL, Tietokantaohjelmointi

Näytä lisää: store image database sql fileupload, asterisk call forward database sql query, add database sql, Soccer football database sql , password database sql anywhere, changes database sql, deploy sql database sql express, converting access database sql server 2008, converting sql 2000 database sql server 2005 express, lunches database sql, spyware database sql, free php web templates database sql hosting nuke, connectionstring provider database sql 2005, for the given table, which point lies on the residual plot? (1, 26) (2, 18.3) (3, 4.6) (4, 19), for the given table, which point lies on the residual plot?(1, 26)(2, 18.3)(3, 4.6)(4, 19), numbers 11 4 6 10 16 24 29 esv, numbers 11:4-6, 10-16, 24-29 nrsv, what is the standard deviation of the data set given below 4 7 8 9 12, what is the standard deviation of the data set given below? 4, 7, 8, 9, 12

Tietoa työnantajasta:
( 0 arvostelua ) jeddah, Turkey

Projektin tunnus: #29461413

Myönnetty käyttäjälle:

fastlabindia

Greetings!. I checked your 'Database my sql -- 4' requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS software, Quer Lisää

$20 USD 2 päivässä
(9 Arvostelua)
3.7

5 freelanceria on tarjonnut keskimäärin $85 tähän työhön

SqlDevelopment

I can efficiently and qualitatively assist with required database development project because I am Senior SQL Developer with 10-plus years of exceptional development experience and with extended professional expertise Lisää

$250 USD 2 päivässä
(40 arvostelua)
5.1
mubashirnoor123

Hi, I have read your requirement and I am confident that I can resolve your query as per your requirement I have expertise in C# MySQL, MSSQL and oracle, access, excel with more than 10 years of experience. But unfortu Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
EgorKovalev

Hello? Nice to meet you. You have confirmed the details of the project you ordered. I am an expert in web server and database management (Mysql, SQL, MS ACCESS). Also, database optimization is my basic skill. Please se Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
bizmanas

Hi I have 15 years of experience in MS SQL Server database programming. I will be able to help you with the project. Please ping me offline to discuss further.

$100 USD 2 päivässä
(1 arvostelu)
0.0