143 reputation
4
bio website N/A
location Canada
age 22
visits member for 1 year, 9 months
seen Jul 5 at 22:32

Mechatronics Engineering Student at University of Waterloo, programming since 2005.


Jan
17
comment At What Point Does Having an Index Become Efficient
While this answer may not directly answer the question, it does much better by giving the important design principles for the index, and answers the question that I should have asked in the first place.
Jan
17
awarded  Scholar
Jan
17
accepted At What Point Does Having an Index Become Efficient
Jan
17
comment At What Point Does Having an Index Become Efficient
Thank you for the article, she presents some interesting points. I was wondering if the inserts would be affected as dramatically as the selects in the small table, but you're right, the tradeoff should be similar at the beginning as it would be later.
Jan
17
comment At What Point Does Having an Index Become Efficient
Are inserts affected similarly, or is the slowdown minimal?
Jan
17
awarded  Student
Jan
17
asked At What Point Does Having an Index Become Efficient
Jan
17
awarded  Supporter
Jan
17
awarded  Autobiographer