Adding an index to a columnThe department name column contains the names of the

Adding an index to a columnThe department name column contains the names of the departments per location. Most all locations have the same departments, with very few exceptions. This column seems well suited for a Bit Map index. Write and execute the statement that would create a new Bit map index for the LOCATION column. Name the index LOC_BM_IDX.Thank you,