class Azure::SQL::Mgmt::V2014_04_01::Models::RecommendedIndex
Represents a database recommended index.
Attributes
@return [RecommendedIndexAction] The proposed index action. You can create a missing index, drop an unused index, or rebuild an existing index to improve its performance. Possible values include: 'Create', 'Drop', 'Rebuild'
@return [Array<String>] Columns over which to build index
@return [DateTime] The UTC datetime showing when this resource was created (ISO8601 format).
@return [Array<OperationImpact>] The estimated impact of doing recommended index action.
@return [Array<String>] The list of column names to be included in the index
@return [String] The full build index script
@return [RecommendedIndexType] The type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE). Possible values include: 'CLUSTERED', 'NONCLUSTERED', 'COLUMNSTORE', 'CLUSTERED COLUMNSTORE'
@return [DateTime] The UTC datetime of when was this resource last changed (ISO8601 format).
@return [Array<OperationImpact>] The values reported after index action is complete.
@return [String] The schema where table to build index over resides
@return [RecommendedIndexState] The current recommendation state. Possible values include: 'Active', 'Pending', 'Executing', 'Verifying', 'Pending Revert', 'Reverting', 'Reverted', 'Ignored', 'Expired', 'Blocked', 'Success'
@return [String] The table on which to build index.
Private Class Methods
Mapper for RecommendedIndex
class as Ruby Hash. This will be used for serialization/deserialization.
# File lib/2014-04-01/generated/azure_mgmt_sql/models/recommended_index.rb, line 70 def self.mapper() { client_side_validation: true, required: false, serialized_name: 'RecommendedIndex', type: { name: 'Composite', class_name: 'RecommendedIndex', model_properties: { id: { client_side_validation: true, required: false, read_only: true, serialized_name: 'id', type: { name: 'String' } }, name: { client_side_validation: true, required: false, read_only: true, serialized_name: 'name', type: { name: 'String' } }, type: { client_side_validation: true, required: false, read_only: true, serialized_name: 'type', type: { name: 'String' } }, action: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.action', type: { name: 'Enum', module: 'RecommendedIndexAction' } }, state: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.state', type: { name: 'Enum', module: 'RecommendedIndexState' } }, created: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.created', type: { name: 'DateTime' } }, last_modified: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.lastModified', type: { name: 'DateTime' } }, index_type: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.indexType', type: { name: 'Enum', module: 'RecommendedIndexType' } }, schema: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.schema', type: { name: 'String' } }, table: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.table', type: { name: 'String' } }, columns: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.columns', type: { name: 'Sequence', element: { client_side_validation: true, required: false, serialized_name: 'StringElementType', type: { name: 'String' } } } }, included_columns: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.includedColumns', type: { name: 'Sequence', element: { client_side_validation: true, required: false, serialized_name: 'StringElementType', type: { name: 'String' } } } }, index_script: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.indexScript', type: { name: 'String' } }, estimated_impact: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.estimatedImpact', type: { name: 'Sequence', element: { client_side_validation: true, required: false, serialized_name: 'OperationImpactElementType', type: { name: 'Composite', class_name: 'OperationImpact' } } } }, reported_impact: { client_side_validation: true, required: false, read_only: true, serialized_name: 'properties.reportedImpact', type: { name: 'Sequence', element: { client_side_validation: true, required: false, serialized_name: 'OperationImpactElementType', type: { name: 'Composite', class_name: 'OperationImpact' } } } } } } } end