Sybase Best Practices
I have been using Sybase for years during my IT career. There are a few commands useful to measure, troubleshoot, tune your SQLs, table design in different perpectives, which are significantly helpful at work. Here are some notes.Basic development considerations
[*]How often is the query run?
[*]How many indexes does the table have?
[*]Will data in the table be dynamic?
[*]Is the query complicated?
[*]How many rows will the related table contain?
[*]How many columns does the table have?
Useful commands in troubleshooting
[*]set statistics io
[*]set statistics time
[*]set showplan
[*]update statistics
set statistics io
[*]Use this command to find out the IO usage, including the cache hit ratio;
[*]IO us an indicative measurement of performance - estimating the work done;
[*]Shows the physical and logical IO used in the query;
[*]Includes any additional IO also from the tempdb.
Output contains
页:
[1]