The best resources to understand
TopicsOptimizationIndexing
A complex and fascinating topic
No statistics to display
How Database Indexes Work
Published on 24/10/2022
Why and how creating indexes can speed up your queries, or slow them down if they are poorly designe...
1%20--%3e%3csvg%20version='1.1'%20id='Layer_1'%20xmlns='http://www.w3.org/2000/svg'%20xmlns:xlink='http://www.w3.org/1999/xlink'%20x='0px'%20y='0px'%20viewBox='0%200%20512.001%20512.001'%20style='enable-background:new%200%200%20512.001%20512.001;'%20xml:space='preserve'%3e%3cpath%20style='fill:%23FF7258;'%20d='M502.691,237.592H369.557c-4.273,0-7.971-2.941-8.962-7.098%20c-9.34-39.149-40.285-69.997-79.487-79.198c-4.173-0.98-7.132-4.684-7.132-8.97V9.242c0-5.496,4.775-9.748,10.24-9.17%20c58.153,6.163,112.04,31.784,153.981,73.714c41.822,41.833,67.426,95.566,73.663,153.553%20C512.447,232.809,508.192,237.592,502.691,237.592z'/%3e%3cpath%20style='fill:%23F95D48;'%20d='M273.976,142.327v-27.398c64.094,7.919,114.929,58.629,123.045,122.665h-27.463%20c-4.273,0-7.971-2.941-8.962-7.098c-9.34-39.149-40.285-69.997-79.487-79.198C276.935,150.318,273.976,146.613,273.976,142.327z'/%3e%3cpath%20style='fill:%23FFDC65;'%20d='M511.949,282.405c-5.128,49.126-24.143,95.221-55.135,133.648c-3.454,4.281-9.844,4.657-13.733,0.767%20l-74.535-74.535l-19.612-19.612c-3.035-3.035-3.549-7.747-1.294-11.399c6.004-9.72,10.491-20.47,13.134-31.921%20c0.968-4.194,4.678-7.177,8.982-7.177H502.78C508.271,272.175,512.52,276.943,511.949,282.405z'/%3e%3cpath%20style='fill:%23FFC846;'%20d='M397.192,272.175c-3.055,26.225-13.269,50.26-28.646,70.11l-19.612-19.612%20c-3.035-3.035-3.549-7.747-1.294-11.399c6.004-9.72,10.491-20.47,13.134-31.921c0.968-4.194,4.678-7.177,8.982-7.177H397.192z'/%3e%3cpath%20style='fill:%2300ABE0;'%20d='M418.671,441.32c3.884,3.884,3.517,10.261-0.75,13.718c-45.519,36.882-101.83,56.943-161.237,56.943%20c-68.554,0-133.015-26.709-181.501-75.182C26.971,388.588,0.302,324.58,0.002,256.46c-0.301-68.411,26.807-134.3,75.182-182.674%20c41.934-41.934,95.828-67.555,153.989-73.714c5.457-0.577,10.219,3.686,10.219,9.173v133.082c0,4.294-2.971,7.994-7.152,8.976%20c-47.164,11.08-82.383,53.492-82.383,103.996c0,58.894,47.92,106.825,106.825,106.825c20.711,0,40.058-5.931,56.447-16.173%20c3.655-2.284,8.392-1.778,11.439,1.269L418.671,441.32z'/%3e%3cpath%20style='fill:%23099DD1;'%20d='M324.571,347.22l19.653,19.653c-24.131,19.06-54.632,30.448-87.785,30.455%20c-78.517,0.017-141.564-62.84-141.772-141.356c-0.194-72.693,54.342-132.695,124.728-141.113v27.467%20c0,4.294-2.971,7.994-7.151,8.976c-47.164,11.08-82.383,53.492-82.383,103.996c0,58.894,47.92,106.825,106.825,106.825%20c20.711,0,40.058-5.931,56.447-16.173C316.787,343.667,321.523,344.173,324.571,347.22z'/%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3cg%3e%3c/g%3e%3c/svg%3e)
1111