okay. i will get the index information. meanwhile, running DTA, shows that i need to create another 2 NC index on table2. I also ranmissing index dmc. It also showed same. Should I create the indexes?