Aqua Data Studio 15.0.0-dev-251
Build #: 37516
Built on: 2014-Apr-24 02:29:32 PM
Connect Sybase ASE:-
1.Go to file menu bar-> select options
2.Option window opens
3.Select Visual Explain and expand it
4.Select sybase ASE visaul explain
5.Select XML type
6.Click on ok button
7.Open a query analyzer and execute below query,
SELECT uid, gid, hashkey, id, sequence, exec_min, exec_max, exec_avg, elap_min, elap_max, elap_avg, lio_min, lio_max, lio_avg, pio_min, pio_max, pio_avg, cnt, abort_cnt, qtext
FROM dbo.sysquerymetrics
8.Click on Execute explain icon.
In Visual explain diagram,value for IndexScan is shown as "0.00%" and "100.00%".
If we compare with the Sybase ASE native tool the visual explain displays Index scan value as "3.00%".
You are comparing 2 different things.