× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
kirtipbankar(*) reported 2014-04-25T11:51:32Z  · tariqrahiman last modified 2014-05-01T23:43:09Z

IndexScan value in Visual Explain diagram seems to be incorrect.


Priority Low
Complexity Unknown
Component Q Analyzer - Visual Explain Diagram
Version 15.0
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%".
 
 
1 attachment
  • 1.jpg

    2014-04-25T11:51:32Z

    393 KB

Issue #11947

Closed
Invalid
Resolved 2014-05-01T23:43:09Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017