BlackLine interview question

MS SQL Related. Mostly optimization technique and IX internals.