Ness Digital Engineering Manager Technical interview questions

• Experience with database optimization? Which would make queries faster? • What is an index? • Different types of indexes and indexes strategies? Explain how to choose one • Put an example of the use of key-reverse index • What kind of improvement would you get with a correct indexing strategy? • What is the cache in database? • When is necessary to apply the cache? • Highlight one situation where is not recommended to use the cache • What kind of improvement will you get if you use cache in queries? Aprox 218% • What decrease will you get if you use cache wrongly? Aprox 13% • Slow queries, how would you detect one? Which tool will you use?