ÿþ<html><head><meta content="text/html; charset=utf-" http-equiv=content-type><meta name="virtualDBA" content="ver 3.1.5"><title>virtualDBA | Database Profile - newsmedia - Index Usage Statistics </title><style type="text/css"><!--a {text-decoration: none;}a:link {COLOR: black;}a:visited {COLOR: black;}.titlerow, .titlerow td{text-align:left;font-family:arial;vertical-align:top;background-color:#6699CC;color:#000000;}.datarow, .datarow td{text-align:left;font-family:arial;vertical-align:top;background-color:#FFFFFF;color:#000000;}--></style></head><body><br><font face="arial"><b><font color="grey">reports.</font>virtualDBA</b><br><br><br><img src="http://static.virtualdba.ca/img/png/samp_logo.png"/><br><br></font><table border=2 cellpadding="5" cellspacing="0" bordercolorlight="#cccccc" bordercolordark="#999999"><tr><td class="titlerow" width="150">Title:</td><td class="datarow" width="500">Database Profile - mydatabae - Index Usage Statistics </td></tr><tr><td class="titlerow" width="150">Description:</td><td class="datarow" width="500">Database Profile - mydatabase - Index usage statistics where scans vs seeks > 75% or maintenance vs user > 75%.</td></tr></table><br><font face="arial"><table border=2 cellpadding="5" cellspacing="0" bordercolorlight="#cccccc" bordercolordark="#999999"><tr class="titlerow"><td>log_date</td><td>database_name</td><td>object_name</td><td>index_name</td><td>user_seeks</td><td>user_scans</td><td>user_lookups</td><td>last_user_update</td><td>maintenance_updates</td><td>percent_scans_vs_seeks</td><td>percent_maintenance_vs_user</td></tr><tr class="datarow"><td>2010-01-26T00:15:00.90</td><td>newsmedia</td><td>tickers</td><td>nc_ndx_ticker_name</td><td>0</td><td>0</td><td>0</td><td>&nbsp</td><td>679</td><td>100.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:00.90</td><td>newsmedia</td><td>instrument</td><td>nc_ndx_ins_name</td><td>0</td><td>0</td><td>0</td><td>&nbsp</td><td>172</td><td>100.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:00.90</td><td>newsmedia</td><td>instrument</td><td>nc_ndx_ins_detail</td><td>0</td><td>0</td><td>0</td><td>&nbsp</td><td>1104</td><td>100.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>Feed</td><td>nc_ndx_lastupdate</td><td>0</td><td>0</td><td>0</td><td>&nbsp</td><td>10964</td><td>100.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>Members</td><td>nc_ndx_status</td><td>90</td><td>0</td><td>0</td><td>2010-01-25T22:14:5.973</td><td>523351</td><td>0.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>Members</td><td>nc_ndx_first_name</td><td>154</td><td>0</td><td>0</td><td>2010-01-25T21:5:1.433</td><td>52257</td><td>0.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>Members</td><td>nc_ndx_alias</td><td>1</td><td>235</td><td>0</td><td>2010-01-25T16:52:33.553</td><td>52257</td><td>99.600</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>fulltext_index_map_96471362</td><td>i4</td><td>0</td><td>0</td><td>0</td><td>&nbsp</td><td>226634</td><td>100.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>fulltext_index_map_37472637</td><td>i3</td><td>0</td><td>0</td><td>0</td><td>&nbsp</td><td>226634</td><td>100.000</td><td>100.00</td></tr><tr class="datarow"><td>2010-01-26T00:15:01.037</td><td>newsmedia</td><td>rssfeed</td><td>nc_ndx_feed_name</td><td>179</td><td>0</td><td>0</td><td>2010-01-25T15:49:50.23</td><td>37912</td><td>0.000</td><td>100.00</td></tr></table></font></font><br><font size="1">2010-01-27 07:22:41.047<br><br><img src="http://www.virtualdba.ca/favicon.ico" /><a href="http://www.virtualdba.ca/">virtualDBA &copy; 2006, All Rights Reserved</a></font><br><br></body></html>