API Reference
  1. Database Optimizer
  2. AdvisorAPI

List combined query and index advisor recommendations

get
https://api.cast.ai/database-optimizer/advisor/v1alpha/organizations//databases//recommendations

List combined query and index recommendations for a database

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required

Organization identifier

string
required

Database identifier

Query Params
string

Defines the number of items that should be returned

string

Cursor that defines token indicating where to start the next page.
Empty value indicates to start from beginning of the dataset.

kinds
array of strings

Filter by recommendation kind — omit to return both query and index

kinds
Allowed:
categories
array of strings

Filter by category (applies to query recommendations only)

categories
Allowed:
impacts
array of strings

Filter by impact (applies to query recommendations only)

impacts
Allowed:
statuses
array of strings

Filter by status

statuses
Allowed:
validationStatuses
array of strings

Filter by validation status — omit to return all regardless of validation status

validationStatuses
Allowed:
Responses

Updated 2 hours ago

Did this page help you?
Language
Credentials
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 2 hours ago

Did this page help you?