Hello Forum, I test dta utility, command line: 1 c:/working/binn/dta -F -D dev2 -E -S wl4243 -d dev2 -if t2.sql -s sess3 -of t1.out -m 20 -fa IDX -rl ALL my t2.sql: select top 1000 * from sourceprices_archive where isin_iix = 'SG1X13940751' This sql produces cl. index recommendation if ran through windows dta. If I run it through command line, it produces xml file and I do not see any new index recommendation. I also want to confirm that sql containing stored procs, temp. tables can not be processed through dta. At least I was not able to get clean run with dta if sql file contains execution of stored procs.
Thank you for your answer. Yes, I did try to use it. However I know the answer already. Need to use -of. If not, it won't display answer on counsel. It was the task to use command line version.
