Create indexes to database
$100-120 USD
Оплачується при отриманні
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!
ID Проекту: #3682526