Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
Cheshire-Cat
-
1
Description
Currently, we support "Advise" in UI.
We also need better support for Advisor.
We can use:
SELECT ADVISOR({"action": "start", "response": "0s", "duration": "1h"}) AS Collect;
that returns a sessionid:
"session": "4b5edc0e-c288-4754-9ac9-1f666b9d31cc"
and starts recoding all the statements until
SELECT ADVISOR({"action": "stop", "session": "4b5edc0e-c288-4754-9ac9-1f666b9d31cc"}) AS Stop;
is issued
or a certain time limit is set.
We then get recommendations by
SELECT ADVISOR({"action": "get", "session": "4b5edc0e-c288-4754-9ac9-1f666b9d31cc"}) AS Get;
Instead of giving all these textually, can we get a nice UI with "Start Advisor", "Stop Advisor","List Recommendations" or a separate tab altogether?
Discussed in meeting with Eben and Rob on Oct 13 2020
Attachments
Issue Links
- depends on
-
MB-39423 UI to support Index Advisor() Function
- Open