Create indexes to database

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

Hello,

Attached you will find a SQL script that creates a database, some select statements of the most frequent operations over that database and a word document that explains other common queries needed on the database. Your job would be to create indexes that help to speed up those queries and also the queries specified on this document. The answer of course can't be an index for every single field on those tables. The database already have some indexes created, please discard those and assume no indexes exists (other than the primary keys). As a deliverable, I expect to things:

* A word document explaining the indexes created and how do they increase or help the performance of the queries provided (both the explicit ones in the SQL script and the explained ones in the word document).

* A SQL script that creates the database with the new indexes.

In your bid, please state your experience in databases. If you can show examples of previous work that will give you an advantage.

Please contact me if you have any question, thanks!

MySQL SQL

ID Проекту: #3682526

Про проект

6 заявок(-ки) Дистанційний проект Остання активність Nov 9, 2011

Доручено:

pradeepsingh37

See private message.

$102 USD за 7 дні(-в)
(12 відгуків(-и))
4.4

6 фрілансерів(-и) готові виконати цю роботу у середньому за $82

siberiangirl

See private message.

$102 USD за 7 дні(-в)
(127 відгуків(и))
6.0
danale72

See private message.

$100.3 USD за 7 дні(-в)
(49 відгуків(и))
5.3
wesolvevw

See private message.

$85 USD за 7 дні(-в)
(40 відгуків(и))
4.7
hungheykwun

See private message.

$50.15 USD за 7 дні(-в)
(26 відгуків(и))
3.1
musawarlx

See private message.

$51 USD за 7 дні(-в)
(0 відгуків(и))
0.0