Esempio n. 1
0
        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());
        }
Esempio n. 2
0
        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());
        }