public string GetDetailInfo()
{
var sb = new StringBuilder();
var name = $"[{SchemaName}].[{TableName}].[{IndexName}]";
sb.AppendLine($"Name: {name} (Reads:{NotAvailableIfNull(UserReads)} Writes:{NotAvailableIfNull(UserWrites)} Size:{IndexSizeMB.ToString("N2")} MB)");
sb.AppendLine($"Indexed Columns: {string.Join(", ", IndexedColumns.Select(c => c.ColumnName + (c.IsDescendingKey ? " (desc)" : "")))}");
sb.AppendLine($"Included Columns: {string.Join(", ", IncludedColumns.Select(c => c.ColumnName))}");
List <string> attribs = GetAttributes();
sb.AppendLine($"Attributes: {string.Join(", ", attribs)}");
sb.AppendLine($"Filter: {FilterDefinition}");
return(sb.ToString());
}
public string GetSummaryInfo()
{
var sb = new StringBuilder();
sb.AppendLine($"{SchemaName}.{TableName}.{IndexName} (Reads:{NotAvailableIfNull(UserReads)} Writes:{NotAvailableIfNull(UserWrites)} Size:{IndexSizeMB.ToString("N2")} MB)");
return(sb.ToString());
}
