private PossibleIndex Convert(DBMS.Contracts.IndexDefinition indexDefinition, long size, Dictionary <string, long> filters) { PossibleIndex result = new PossibleIndex(); result.RelationID = indexDefinition.Relation.ID; result.CreateDefinition = dbObjectDefinitionGenerator.Generate(indexDefinition).CreateStatement; result.FilterExpressions = new PossibleIndexFilterExpressionsData(); foreach (var f in filters) { result.FilterExpressions.Expressions.Add(new PossibleIndexFilterExpression() { Expression = f.Key, Size = f.Value }); } result.Name = indexDefinition.Name; result.Size = size; return(result); }
private WorkloadAnalysisEnvironmentIndexExtended Convert(PossibleIndex source) { WorkloadAnalysisEnvironmentIndexExtended result = new WorkloadAnalysisEnvironmentIndexExtended(); result.CreateDefinition = source.CreateDefinition; if (source.FilterExpressions != null && source.FilterExpressions.Expressions != null) { foreach (var item in source.FilterExpressions.Expressions) { result.Filters.Add(item.Expression, item.Size); } } result.ID = source.ID; result.Name = source.Name; result.RelationID = source.RelationID; result.Size = source.Size; return(result); }
private VirtualEnvironmentPossibleCoveringIndex Convert(VirtualEnvironment env, long statementID, PossibleIndex createdIndex) { return(new VirtualEnvironmentPossibleCoveringIndex() { VirtualEnvironmentID = env.ID, PossibleIndexID = createdIndex.ID, NormalizedStatementID = statementID, }); }
private VirtualEnvironmentPossibleIndex Convert(VirtualEnvironment environment, PossibleIndex possibleIndex, VirtualIndicesEnvironmentIndexEvaluation indexEval) { VirtualEnvironmentPossibleIndex result = new VirtualEnvironmentPossibleIndex(); result.PossibleIndexID = possibleIndex.ID; result.VirtualEnvironemntID = environment.ID; result.ImprovementRatio = indexEval.ImprovementRatio; return(result); }