The wonderful ( dare I say "cool"? :) new V17 dbisql Compare Plans feature does an almost perfect job of comparing two *.saplan files created by SQL Anywhere 16, but a text comparison of the files indicates that at least one item is missed:

The Advanced Details tab of the top-most SELECT node contains the following message in one *.saplan file but not the other, and Compare Plan does not show the difference.

(Some materialized views may have been ignored: the query uses an updatable cursor)

asked 13 Oct '15, 09:02

Breck%20Carter's gravatar image

Breck Carter
27.0k424582830
accept rate: 21%

edited 13 Oct '15, 09:04

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×1

question asked: 13 Oct '15, 09:02

question was seen: 1,723 times

last updated: 13 Oct '15, 09:04

Related questions