Re: What system table shows when a table was last analyzed?

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

: Select * from dict_columns where column_name like '%ANALYZE%'
: should also have done the tric.
: Please use it next time to avoid questions you could easily have
: looked up yourself.

Hey! That didn't work. All I got was a 2> ;-) ;-)

Thanks. I was trying to puzzle out what turned out to be

        Select * from user_tables;

When I stumbled onto this thread.

These things are hard to locate in the online ref manuals, but are being tucked away in my handy-lines.txt for cutting and pasting later.

-- 
---
Clarence A Dold - dold_at_email.rahul.net
                - Hidden Valley (Lake County) CA.