API Documentation

Last Update: 28 December 2022

POST api/MSSQLDatabaseMissingIndex



Request Information


URI Parameters

None.


Body Parameters
MSSQLDatabaseMissingIndex
Name Description Type Additional information
ID

integer

None.
ReportDate

date

None.
DatabaseLocalID

integer

None.
HostID

integer

None.
DatabaseGuid

string

None.
IndexAdvantage

integer

None.
LastUserSeek

date

None.
TableName

string

None.
EqualityColumns

string

None.
InequalityColumns

string

None.
IncludedColumns

string

None.
UniqueCompiles

integer

None.
UserSeeks

integer

None.
UserCost

decimal number

None.
UserImpact

decimal number

None.
ProposedIndex

string

None.
RecordStatus

integer

None.
Request Formats
application/json, text/json
Sample: 
{
  "ID": 1,
  "ReportDate": "2024-11-21T06:23:43.3051092+00:00",
  "DatabaseLocalID": 3,
  "HostID": 4,
  "DatabaseGuid": "sample string 5",
  "IndexAdvantage": 6,
  "LastUserSeek": "2024-11-21T06:23:43.3051092+00:00",
  "TableName": "sample string 8",
  "EqualityColumns": "sample string 9",
  "InequalityColumns": "sample string 10",
  "IncludedColumns": "sample string 11",
  "UniqueCompiles": 12,
  "UserSeeks": 13,
  "UserCost": 14.1,
  "UserImpact": 15.1,
  "ProposedIndex": "sample string 16",
  "RecordStatus": 17
}

Response Information


Resource Description
MSSQLDatabaseMissingIndex
Name Description Type Additional information
ID

integer

None.
ReportDate

date

None.
DatabaseLocalID

integer

None.
HostID

integer

None.
DatabaseGuid

string

None.
IndexAdvantage

integer

None.
LastUserSeek

date

None.
TableName

string

None.
EqualityColumns

string

None.
InequalityColumns

string

None.
IncludedColumns

string

None.
UniqueCompiles

integer

None.
UserSeeks

integer

None.
UserCost

decimal number

None.
UserImpact

decimal number

None.
ProposedIndex

string

None.
RecordStatus

integer

None.
Response Formats
application/json, text/json
Sample: 
{
  "ID": 1,
  "ReportDate": "2024-11-21T06:23:43.3109499+00:00",
  "DatabaseLocalID": 3,
  "HostID": 4,
  "DatabaseGuid": "sample string 5",
  "IndexAdvantage": 6,
  "LastUserSeek": "2024-11-21T06:23:43.3109499+00:00",
  "TableName": "sample string 8",
  "EqualityColumns": "sample string 9",
  "InequalityColumns": "sample string 10",
  "IncludedColumns": "sample string 11",
  "UniqueCompiles": 12,
  "UserSeeks": 13,
  "UserCost": 14.1,
  "UserImpact": 15.1,
  "ProposedIndex": "sample string 16",
  "RecordStatus": 17
}