| analyze table and public synonyms? [message #10980] |
Thu, 26 February 2004 23:51 |
Sheldon Damons
Messages: 3
Registered: February 2004
|
Junior Member |
|
|
Is there a way of executing
analyze table UserSchema.MyTable estimate statistics;
without having to include the schema name? e.g.
analyze table MyTable estimate statistics;
I have tried setting up public synonyms for MyTable but analyze table does not seem to check Public Synonyms for Table name...
Thankx in advance..
Sheldon
... this will most definitely put a smile on my dial!!!
:-}
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
