Indexes are used to speed up searching on columns within tables. They can increase performance if used correctly but can also have costs as the index record must be updated with every change. Primary keys will become indexes by default.
About CDB 361 Articles
Self-Employed Software Developer, Spark, Property Management, Hobby Forestry, Ex-Teacher, Engineering - Wood, Metal, Electrics & Computers. Outdoors - Walk, Cycle, Kitesurf,