{"id":73,"date":"2010-02-26T16:50:43","date_gmt":"2010-02-26T21:50:43","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=73"},"modified":"2014-11-13T14:04:29","modified_gmt":"2014-11-13T19:04:29","slug":"index-views-indexphysical","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/","title":{"rendered":"Index Views: IndexPhysical"},"content":{"rendered":"

With this post I am going to start a series about queries that I find helpful while researching indexes and index issues. In fact, because I use them often, I encapsulated them in views.<\/span><\/span><\/p>\n

<\/p>\n

The first one is SATools<\/span>.<\/span><\/span>IndexPhysical<\/span>:<\/span><\/span><\/span><\/span><\/p>\n

<\/p>\n\n\n\n
\n

CREATE<\/span> VIEW<\/span> SATools<\/span>.<\/span>IndexPhysical<\/span><\/span><\/span><\/p>\n

AS<\/span><\/span><\/p>\n

SELECT<\/span> OBJECT_NAME<\/span>(<\/span>i<\/span>.<\/span>object_id<\/span>)<\/span> Tbl<\/span>,<\/span><\/span><\/span><\/p>\n

i.<\/span>name Idx,<\/span><\/span><\/span><\/p>\n

i.<\/span>type_desc TYPE<\/span>,<\/span><\/span><\/span><\/p>\n

ps.<\/span>partition_number AS<\/span> Partition<\/span>,<\/span><\/span><\/span><\/p>\n

ps.<\/span>index_level AS<\/span> Level<\/span>,<\/span><\/span><\/span><\/p>\n

ps.<\/span>alloc_unit_type_desc AS<\/span> DataType,<\/span><\/span><\/span><\/p>\n

ps.<\/span>record_count AS<\/span> Records,<\/span><\/span><\/span><\/p>\n

ps.<\/span>page_count AS<\/span> Pages,<\/span><\/span><\/span><\/p>\n

ps.<\/span>fragment_count AS<\/span> Fragments,<\/span><\/span><\/span><\/p>\n

ps.<\/span>avg_fragmentation_in_percent AS<\/span> FragPerc,<\/span><\/span><\/span><\/p>\n

ps.<\/span>min_record_size_in_bytes AS<\/span> MinRecBytes,<\/span><\/span><\/span><\/p>\n

ps.<\/span>avg_record_size_in_bytes AS<\/span> AvgRecBytes,<\/span><\/span><\/span><\/p>\n

ps.<\/span>max_record_size_in_bytes AS<\/span> MaxRecBytes,<\/span><\/span><\/span><\/p>\n

ps.<\/span>avg_page_space_used_in_percent AS<\/span> PageSpaceUsedPerc<\/span><\/span><\/p>\n

FROM<\/span> sys<\/span>.<\/span>indexes<\/span> AS<\/span> i<\/span><\/span><\/span><\/p>\n

JOIN<\/span> sys<\/span>.<\/span>dm_db_index_physical_stats<\/span>(<\/span>DB_ID<\/span>(),<\/span> DEFAULT<\/span>,<\/span> DEFAULT<\/span>,<\/span> DEFAULT<\/span>,<\/span><\/span><\/span><\/p>\n

'DETAILED'<\/span>)<\/span> AS<\/span> ps<\/span><\/span><\/span><\/p>\n

ON<\/span> i<\/span>.<\/span>object_id<\/span> =<\/span> ps<\/span>.<\/span>object_id<\/span> AND<\/span><\/span><\/span><\/p>\n

i.<\/span>index_id =<\/span> ps.<\/span>index_id;<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

This view gives you information about Index depth, approximate number of records, average page fullness and average page fragmentation.<\/span><\/span><\/p>\n

Take for example this table:<\/span><\/span><\/p>\n

<\/p>\n\n\n\n
\n

IF OBJECT_ID<\/span>(<\/span>'dbo.IndexTest'<\/span>)<\/span> IS<\/span> NOT<\/span> NULL<\/span> <\/span><\/span><\/p>\n

DROP<\/span> TABLE<\/span> dbo<\/span>.<\/span>IndexTest<\/span> ;<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/p>\n

CREATE<\/span> TABLE<\/span> dbo<\/span>.<\/span>IndexTest<\/span> (<\/span>Id<\/span> INT<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_PK<\/span> PRIMARY<\/span> KEY<\/span> CLUSTERED<\/span>,<\/span><\/span><\/span><\/p>\n

Uk INT<\/span> NOT<\/span> NULL,<\/span><\/span><\/span><\/p>\n

IdxFill CHAR<\/span>(<\/span>800)<\/span><\/span><\/span><\/p>\n

NOT<\/span> NULL<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_IdxFill_Dflt<\/span><\/span><\/span><\/p>\n

DEFAULT<\/span> REPLICATE<\/span>(<\/span>'I'<\/span>,<\/span> 800<\/span>),<\/span><\/span><\/span><\/p>\n

PageFill CHAR<\/span>(<\/span>7000)<\/span><\/span><\/span><\/p>\n

NOT<\/span> NULL<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_PageFill_Dflt<\/span><\/span><\/span><\/p>\n

DEFAULT<\/span> REPLICATE<\/span>(<\/span>'P'<\/span>,<\/span> 7000<\/span>),<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_U1<\/span> UNIQUE<\/span> (<\/span>Uk<\/span>,<\/span> IdxFill<\/span>)<\/span><\/span><\/span><\/p>\n

)<\/span> ;<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/p>\n

INSERT<\/span> INTO<\/span> dbo<\/span>.<\/span>IndexTest<\/span><\/span><\/span><\/p>\n

(<\/span>Id<\/span>,<\/span><\/span><\/span><\/p>\n

Uk<\/span><\/span><\/p>\n

)<\/span><\/span><\/p>\n

SELECT<\/span> n<\/span>,<\/span><\/span><\/span><\/p>\n

CHECKSUM<\/span>(<\/span>NEWID<\/span>())<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>GetNums<\/span>(<\/span>1000<\/span>)<\/span> ;<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

It contains two integer columns and to fill columns. The fill columns serve the purpose of filling enough pages, so that we get to see multiple levels in the indexes. There are two (implicit) indexes declared on this table. It is filled with 1000 rows using Itzik's GetNums function<\/a>.<\/span><\/p>\n

SATools<\/span><\/span>.<\/span><\/span>IndexPhysical<\/span><\/span> returns this information:<\/span><\/p>\n

<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Tbl<\/span><\/p>\n<\/td>\n

\n

Idx<\/span><\/p>\n<\/td>\n

\n

TYPE<\/span><\/p>\n<\/td>\n

\n

Partition<\/span><\/p>\n<\/td>\n

\n

Level<\/span><\/p>\n<\/td>\n

\n

DataType<\/span><\/p>\n<\/td>\n

\n

Records<\/span><\/p>\n<\/td>\n

\n

Pages<\/span><\/p>\n<\/td>\n

\n

Fragments<\/span><\/p>\n<\/td>\n

\n

FragPerc<\/span><\/p>\n<\/td>\n

\n

MinRecBytes<\/span><\/p>\n<\/td>\n

\n

AvgRecBytes<\/span><\/p>\n<\/td>\n

\n

MaxRecBytes<\/span><\/p>\n<\/td>\n

\n

PageSpaceUsedPerc<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

1000<\/span><\/p>\n<\/td>\n

\n

1000<\/span><\/p>\n<\/td>\n

\n

5<\/span><\/p>\n<\/td>\n

\n

0.4<\/span><\/p>\n<\/td>\n

\n

7815<\/span><\/p>\n<\/td>\n

\n

7815<\/span><\/p>\n<\/td>\n

\n

7815<\/span><\/p>\n<\/td>\n

\n

96.5530022238695<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

1000<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

11<\/span><\/p>\n<\/td>\n

\n

11<\/span><\/p>\n<\/td>\n

\n

11<\/span><\/p>\n<\/td>\n

\n

53.5128984432913<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

11<\/span><\/p>\n<\/td>\n

\n

11<\/span><\/p>\n<\/td>\n

\n

11<\/span><\/p>\n<\/td>\n

\n

0.457128737336299<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_U1<\/span><\/p>\n<\/td>\n

\n

NONCLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

1000<\/span><\/p>\n<\/td>\n

\n

112<\/span><\/p>\n<\/td>\n

\n

30<\/span><\/p>\n<\/td>\n

\n

25<\/span><\/p>\n<\/td>\n

\n

809<\/span><\/p>\n<\/td>\n

\n

809<\/span><\/p>\n<\/td>\n

\n

809<\/span><\/p>\n<\/td>\n

\n

89.437509266123<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_U1<\/span><\/p>\n<\/td>\n

\n

NONCLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

112<\/span><\/p>\n<\/td>\n

\n

27<\/span><\/p>\n<\/td>\n

\n

27<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

41.6412774894984<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_U1<\/span><\/p>\n<\/td>\n

\n

NONCLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

27<\/span><\/p>\n<\/td>\n

\n

6<\/span><\/p>\n<\/td>\n

\n

6<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

45.1754385964912<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_U1<\/span><\/p>\n<\/td>\n

\n

NONCLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

6<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

811<\/span><\/p>\n<\/td>\n

\n

60.2421546824809<\/span><\/p>\n<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

It shows nicely the tree levels of the clustered index and the four levels of the nonclustered index and how many records and how many pages are part of each index level.<\/span><\/p>\n

<\/p>\n

If you have a table, that is partitioned like this<\/span><\/p>\n

<\/p>\n\n\n\n
\n

CREATE<\/span> PARTITION<\/span> FUNCTION<\/span> IndexTest_PF<\/span>(<\/span>SMALLINT<\/span>)<\/span> AS<\/span> RANGE<\/span> LEFT<\/span> FOR<\/span> VALUES<\/span> (<\/span>0<\/span>)<\/span> ;
<\/span>GO
CREATE<\/span> PARTITION<\/span> SCHEME IndexTest_PS<\/span> AS<\/span> PARTITION<\/span> IndexTest_PF<\/span> ALL<\/span> TO<\/span> (<\/span>[PRIMARY]<\/span>)<\/span> ;
<\/span>GO<\/span><\/span><\/span><\/p>\n

CREATE<\/span> TABLE<\/span> dbo<\/span>.<\/span>IndexTest<\/span> (<\/span>Id<\/span> INT<\/span>,<\/span><\/span><\/span><\/p>\n

ArchiveInd<\/span> SMALLINT<\/span><\/span><\/span><\/p>\n

NOT<\/span> NULL<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_ArchiveInd_Dflt<\/span> DEFAULT<\/span> 0<\/span>,<\/span><\/span><\/span><\/p>\n

PageFill<\/span> CHAR<\/span>(<\/span>3000<\/span>)<\/span><\/span><\/span><\/p>\n

NOT<\/span> NULL<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_PageFill_Dflt<\/span><\/span><\/span><\/p>\n

DEFAULT<\/span> REPLICATE<\/span>(<\/span>'P'<\/span>,<\/span> 3000<\/span>),<\/span><\/span><\/span><\/p>\n

CONSTRAINT<\/span> IndexTest_PK<\/span> PRIMARY<\/span> KEY<\/span> CLUSTERED<\/span><\/span><\/span><\/p>\n

(<\/span>Id<\/span>,<\/span> ArchiveInd<\/span>)<\/span> ON<\/span> IndexTest_PS<\/span> (<\/span> ArchiveInd<\/span>)<\/span><\/span><\/span><\/p>\n

)<\/span> ;<\/span><\/span><\/span><\/p>\n

GO<\/span><\/span><\/span><\/p>\n

INSERT<\/span> INTO<\/span> dbo<\/span>.<\/span>IndexTest<\/span><\/span><\/span><\/p>\n

(<\/span>Id<\/span>,<\/span><\/span><\/span><\/p>\n

ArchiveInd<\/span><\/span><\/span><\/p>\n

)<\/span><\/span><\/span><\/p>\n

SELECT<\/span> n<\/span>,<\/span><\/span><\/span><\/p>\n

SIGN<\/span>(<\/span>ABS<\/span>(<\/span>CHECKSUM<\/span>(<\/span>NEWID<\/span>()))<\/span> %<\/span> 5<\/span>)<\/span><\/span><\/span><\/p>\n

FROM<\/span> dbo<\/span>.<\/span>GetNums<\/span>(2<\/span>000<\/span>)<\/span> ;<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

SATools<\/span><\/span>.<\/span><\/span>IndexPhysical<\/span><\/span> returns this information:<\/span><\/p>\n

<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Tbl<\/span><\/p>\n<\/td>\n

\n

Idx<\/span><\/p>\n<\/td>\n

\n

TYPE<\/span><\/p>\n<\/td>\n

\n

Partition<\/span><\/p>\n<\/td>\n

\n

Level<\/span><\/p>\n<\/td>\n

\n

DataType<\/span><\/p>\n<\/td>\n

\n

Records<\/span><\/p>\n<\/td>\n

\n

Pages<\/span><\/p>\n<\/td>\n

\n

Fragments<\/span><\/p>\n<\/td>\n

\n

FragPerc<\/span><\/p>\n<\/td>\n

\n

MinRecBytes<\/span><\/p>\n<\/td>\n

\n

AvgRecBytes<\/span><\/p>\n<\/td>\n

\n

MaxRecBytes<\/span><\/p>\n<\/td>\n

\n

PageSpaceUsedPerc<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

374<\/span><\/p>\n<\/td>\n

\n

187<\/span><\/p>\n<\/td>\n

\n

4<\/span><\/p>\n<\/td>\n

\n

1.6<\/span><\/p>\n<\/td>\n

\n

3013<\/span><\/p>\n<\/td>\n

\n

3013<\/span><\/p>\n<\/td>\n

\n

3013<\/span><\/p>\n<\/td>\n

\n

74.47<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

187<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

34.63<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

1626<\/span><\/p>\n<\/td>\n

\n

813<\/span><\/p>\n<\/td>\n

\n

6<\/span><\/p>\n<\/td>\n

\n

0.62<\/span><\/p>\n<\/td>\n

\n

3013<\/span><\/p>\n<\/td>\n

\n

3013<\/span><\/p>\n<\/td>\n

\n

3013<\/span><\/p>\n<\/td>\n

\n

74.47<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

813<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

50.2<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

IndexTest<\/span><\/p>\n<\/td>\n

\n

IndexTest_PK<\/span><\/p>\n<\/td>\n

\n

CLUSTERED<\/span><\/p>\n<\/td>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

2<\/span><\/p>\n<\/td>\n

\n

IN_ROW_DATA<\/span><\/p>\n<\/td>\n

\n

3<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

1<\/span><\/p>\n<\/td>\n

\n

0<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

13<\/span><\/p>\n<\/td>\n

\n

0.53<\/span><\/p>\n<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

Here you can see that the clustered index has two partitions. Partition 1 has two index levels and partition 2 has three index levels.<\/span><\/p>\n

<\/p>\n

I both cases you can see how badly (in percent) each index level is fragmented (Column FragPerc). You also can get information about the length of each record in the index (level 0) or the length of each key (level > 0). In these examples Min, Avg and Max Bytes per Record are the same, because all fields are fixed length. If you have variable length fields, you will get different values here.<\/span><\/p>\n

\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

With this post I am going to start a series about queries that I find helpful while researching indexes and index issues. In fact, because I use them often, I encapsulated them in views. The first one is SATools.IndexPhysical: CREATE [more…]<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[5],"tags":[],"class_list":["post-73","post","type-post","status-publish","format-standard","hentry","category-general"],"acf":[],"yoast_head":"\nIndex Views: IndexPhysical<\/title>\n<meta name=\"description\" content=\"This post introduces the view IndexPysical that gives returns information about the physical properties of tables in the database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Index Views: IndexPhysical\" \/>\n<meta property=\"og:description\" content=\"This post introduces the view IndexPysical that gives returns information about the physical properties of tables in the database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2010-02-26T21:50:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T19:04:29+00:00\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"Index Views: IndexPhysical\",\"datePublished\":\"2010-02-26T21:50:43+00:00\",\"dateModified\":\"2014-11-13T19:04:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/\"},\"wordCount\":647,\"commentCount\":0,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/\",\"name\":\"Index Views: IndexPhysical\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"datePublished\":\"2010-02-26T21:50:43+00:00\",\"dateModified\":\"2014-11-13T19:04:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"This post introduces the view IndexPysical that gives returns information about the physical properties of tables in the database\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/73\\\/index-views-indexphysical\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Index Views: IndexPhysical\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Index Views: IndexPhysical","description":"This post introduces the view IndexPysical that gives returns information about the physical properties of tables in the database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/","og_locale":"en_US","og_type":"article","og_title":"Index Views: IndexPhysical","og_description":"This post introduces the view IndexPysical that gives returns information about the physical properties of tables in the database","og_url":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2010-02-26T21:50:43+00:00","article_modified_time":"2014-11-13T19:04:29+00:00","author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"Index Views: IndexPhysical","datePublished":"2010-02-26T21:50:43+00:00","dateModified":"2014-11-13T19:04:29+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/"},"wordCount":647,"commentCount":0,"articleSection":["General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/","url":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/","name":"Index Views: IndexPhysical","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"datePublished":"2010-02-26T21:50:43+00:00","dateModified":"2014-11-13T19:04:29+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"This post introduces the view IndexPysical that gives returns information about the physical properties of tables in the database","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/73\/index-views-indexphysical\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"Index Views: IndexPhysical"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-1b","jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}