Just a follow-up from this question on DBVALID:
If my understanding of John's clarifications in the cited question is correct, then DBVALID with no arguments does a VALIDATE DATABASE and a VALIDATE TABLE for each table/materialized view and a VALIDATE INDEX for each index.
Currently, the SA 12 docs state that ...
For sa_validate(), the SA 12 docs (as corrected in DCX) specify, that....
So, is my conclusion correct that both DBVALID with no arguments and sa_validate() with no arguments perform the same set of checks?
If so, that might be another reason the clarify the docs:)
Yes, a default invocation of dbvalid appears to be equivalent to calling sa_validate() with no userid & no table name. For the record, I didn't say that dbvalid executes VALIDATE INDEX for each index. It executes VALIDATE TABLE for each table which also validates all indexes on the table.
The documentation also says that VALIDATE INDEX is a "complement" to the checking done by VALIDATE TABLE but it looks like that is not the case. VALIDATE TABLE actually does slightly more index checking than VALIDATE INDEX does.
answered 15 Oct '10, 19:14