Database my sql -- 4
$10-30 USD
Dibayar semasa penghantaran
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
ID Projek: #29461413
Tentang projek
Dianugerahkan kepada:
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 Lagi
5 pekerja bebas membida secara purata $85 untuk pekerjaan ini
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 Lagi
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 Lagi
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 Lagi
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.