Hi all, according to the SA 11 and above docs, there seems to be a (slight) difference between running
and
From the SA 11.0.1 docs:
(Frankly, I can't tell whether both descriptions mean the same thing...) But in my SQL understanding, both calls should do exactly the same, as all parameters of sa_validate are declared with null as default, and so both calls should be equivalent (and in my tests, they run equally long). So what's the difference between both calls? asked 28 Jun '10, 13:44 Volker Barth |
The statement:
and the statement
are equivalent. As for the documentation, it does seem a bit strange that it would say the same thing twice but in different ways. I believe that Justin is correct and it just an historical thing. I have sent a note to the doc team to remove the duplication. answered 28 Jun '10, 17:51 Mark Culp Thanks - I agree with Justin and you. And I'm pleased to get "officially confirmed" that my reading of the procedure's signature is right:) FWIW: As Mark has announced, the first cited statement in my question has been removed from the DCX version of the SA 12 docs, cf. http://dcx.sybase.com/index.html#1200en/dbreference/sa-validate-sysproc.html. |
It certainly reads like the same things happen in both cases, but if that's true, why do they explain the two cases separately - maybe it's an artifact of the process of editing the article over the years?
@Justin: I have been unsure about the index part, i.e. whether "validating indexes" means validating "that the number of rows in the each table or materialized view matches the number of rows in each associated index". But as Mark states, this is the case.