• All options are true except this one

    "CREATE CLUSTERED INDEX IDX_A ON #temp1(i,a)"

    You should correct your question.

    Igor Micev,My blog: www.igormicev.com