How to Refresh User_tables [message #602370] |
Tue, 03 December 2013 12:31 |
|
9390512774
Messages: 103 Registered: January 2011 Location: hyd
|
Senior Member |
|
|
Hi Experts,
I have a table Emp. This table has 14 rows. when I queried on USER_TABLES for knowing the total number of records it's showing Zero.
If I want to refresh my user_tables table to get the latest statistics of the Emp table. How to do the refreshing of a tables info in metadata like user_tables.
THANKS IN ADVANCE.
|
|
|
|
Re: How to Refresh User_tables [message #602397 is a reply to message #602370] |
Wed, 04 December 2013 00:48 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
9390512774 wrote on Tue, 03 December 2013 18:31
If I want to refresh my user_tables table to get the latest statistics of the Emp table.
To summarise the document that Blackswan kindly pointed you to, you need to gather statistics on any and all tables that you want such results from.
[Updated on: Wed, 04 December 2013 00:49] Report message to a moderator
|
|
|