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:) |
@Breck: Thanks for the correction (cf. http://sqla.stackexchange.com/revisions/1215/list) - oh well, I'd nearly written sa_failidate()...