reports.virtualDBA

Title:	Database Profile - mydatabae - Index Usage Statistics
Description:	Database Profile - mydatabase - Index usage statistics where scans vs seeks > 75% or maintenance vs user > 75%.

log_date	database_name	object_name	index_name	user_seeks	user_scans	user_lookups	last_user_update	maintenance_updates	percent_scans_vs_seeks	percent_maintenance_vs_user
2010-01-26T00:15:00.90	newsmedia	tickers	nc_ndx_ticker_name	0	0	0		679	100.000	100.00
2010-01-26T00:15:00.90	newsmedia	instrument	nc_ndx_ins_name	0	0	0		172	100.000	100.00
2010-01-26T00:15:00.90	newsmedia	instrument	nc_ndx_ins_detail	0	0	0		1104	100.000	100.00
2010-01-26T00:15:01.037	newsmedia	Feed	nc_ndx_lastupdate	0	0	0		10964	100.000	100.00
2010-01-26T00:15:01.037	newsmedia	Members	nc_ndx_status	90	0	0	2010-01-25T22:14:5.973	523351	0.000	100.00
2010-01-26T00:15:01.037	newsmedia	Members	nc_ndx_first_name	154	0	0	2010-01-25T21:5:1.433	52257	0.000	100.00
2010-01-26T00:15:01.037	newsmedia	Members	nc_ndx_alias	1	235	0	2010-01-25T16:52:33.553	52257	99.600	100.00
2010-01-26T00:15:01.037	newsmedia	fulltext_index_map_96471362	i4	0	0	0		226634	100.000	100.00
2010-01-26T00:15:01.037	newsmedia	fulltext_index_map_37472637	i3	0	0	0		226634	100.000	100.00
2010-01-26T00:15:01.037	newsmedia	rssfeed	nc_ndx_feed_name	179	0	0	2010-01-25T15:49:50.23	37912	0.000	100.00

2010-01-27 07:22:41.047

virtualDBA © 2006, All Rights Reserved

਍