Monday, February 3, 2020

Answer for SQL Index exercise

https://365datascience.com/dwqa-answer/answer-for-sql-index-exercise-2/ - Hi Josh!
Thanks for reaching out.
Although in this example on some machines the fetch time actually increases when applying the index, the fact is that when your database is much larger, this difference can be reverted significantly, and in that case using indexes will be crucial. That's why this technique is important and the theory provided in the lectures is actually, in general, valid.
Just depending on computer settings, Workbench version and the like, the fetch time appears slower with indexes in this example for some machines, apparently.
Hope this clarifies the situation but thanks for sharing this information with our Community!
Best,
Martin

#365datascience #datascience #data #science #365datascience #bigdata #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #machinelearning #machine #learning #certificate #udemy #2020

No comments:

Post a Comment