A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?()
- Adb2advis -d proddb -i workload.sql -P
- Bdb2advis -d proddb -i workload.sql -partitioning
- Cdb2advis -d proddb -i workload.sql -m P
- Ddb2advis -d proddb -i workload.sql -m ALL&e