The two primary types of indexes in SQL Server are on$-$disk indexes and memory$-$optimized indexes. Compare and contrast the two types, discussing their characteristics as well as their use cases. Then, give two examples of tables and queries that would be well suited to each type of index $($total of four examples$).$ What security vulnerabilities need to be considered when employing either of the index types?