on 2019 Jan 23 2:24 AM
where can i find the source code for predefined system procedure like CALL sa_table_page_usage(), CALL sa_table_stats(), CALL sa_table_fragmentation() etc..
In addition to Reimer's answer, you may get more hints when searching within this forum, e.g. here is a discussion what the internal gear behind sa_table_fragmentation() might query:
What is the Sybase Central 16 "Fragmentation" tab showing?
Of course that usually won't answer what exact query the stored procedures perform if that is not contained within the SYSPROCEDURE's contents. Note, for sa_table_stats() and sa_table_fragmentation() the procedures's definitions is documented there - for the latter, at least partly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
While you might view the source code using this SQL statement
select proc_defn from sys.sysprocedure where proc_name = 'sa_table_page_usage'you won't get much information apart form the parameter declaration. System procedures call interal functions whose code isn't accessible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.