{"id":3081,"date":"2019-12-23T16:36:01","date_gmt":"2019-12-23T16:36:01","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3081"},"modified":"2025-10-30T15:25:43","modified_gmt":"2025-10-30T15:25:43","slug":"to-index-or-not-to-index","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/chapter\/to-index-or-not-to-index\/","title":{"raw":"To Index or Not to Index?","rendered":"To Index or Not to Index?"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Determine when to use an index<\/li>\r\n<\/ul>\r\n<\/div>\r\nDespite the stated advantages of indexing, there are some drawbacks as well. Indexes add metadata to the database, which increases its size and disk space requirements. In addition, when a new record is added to an indexed table, there is a slight performance hit\u2014for 20 indexes on a table, Access will make 20 adjustments when a new record is added or subtracted. So, you will want to avoid indexing on smaller tables or tables that are not frequently involved in queries.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/68928d1c-b0f1-4424-b22f-b04e29f02b09\r\n\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Determine when to use an index<\/li>\n<\/ul>\n<\/div>\n<p>Despite the stated advantages of indexing, there are some drawbacks as well. Indexes add metadata to the database, which increases its size and disk space requirements. In addition, when a new record is added to an indexed table, there is a slight performance hit\u2014for 20 indexes on a table, Access will make 20 adjustments when a new record is added or subtracted. So, you will want to avoid indexing on smaller tables or tables that are not frequently involved in queries.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_68928d1c-b0f1-4424-b22f-b04e29f02b09\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/68928d1c-b0f1-4424-b22f-b04e29f02b09?iframe_resize_id=assessment_practice_id_68928d1c-b0f1-4424-b22f-b04e29f02b09\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3081\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>To Index or Not to Index?. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":14,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"To Index or Not to Index?\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"372438b4-4846-4304-a5cf-d6bed9a632d0, 77adc849-fe24-4a73-81c6-73dd1d642425","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3081","chapter","type-chapter","status-publish","hentry"],"part":2773,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":8,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3081\/revisions"}],"predecessor-version":[{"id":5563,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3081\/revisions\/5563"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/parts\/2773"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3081\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/media?parent=3081"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapter-type?post=3081"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/contributor?post=3081"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/license?post=3081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}