{"version":"1.0","provider_name":"IRI","provider_url":"https:\/\/www.iri.com\/blog","author_name":"Don Purnhagen","author_url":"https:\/\/www.iri.com\/blog\/author\/donp\/","title":"Database Reorgs - Why They Matter","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"4mo93kG6y9\"><a href=\"https:\/\/www.iri.com\/blog\/vldb-operations\/database-reorgs-why-they-matter\/\">Database Reorgs &#8211; Why They Matter<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.iri.com\/blog\/vldb-operations\/database-reorgs-why-they-matter\/embed\/#?secret=4mo93kG6y9\" width=\"600\" height=\"338\" title=\"&#8220;Database Reorgs &#8211; Why They Matter&#8221; &#8212; IRI\" data-secret=\"4mo93kG6y9\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","thumbnail_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2012\/06\/data-wall.jpg","thumbnail_width":858,"thumbnail_height":643,"description":"Database Reorgs: \u00a0Why They Matter, and the Difference between On-Line and Off-Line Database reorgs are performed to save data space and improve database efficiency and performance. \u00a0This article explains why. The next\u00a0article shows how to reorg multiple tables and databases in Eclipse. Data in large RDBMS tables eventually become fragmented. The size of tables andRead More"}