i've been encountering heavy I/O on single table with more than 1million rows.
a table contains 4 index including single clustered index on it. i've been testing also the stored procedure and got no problem using the index while testing the stored procedure. any suggestions to speed up the access on that particular table.
sorry for noob question. just beginning to understand and study sybase. tnx for your inputs.