Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

SQL Anywhere

I ran the index consultant on my application and it came back with no recommended index's. Looking at the Request Tab there are 7 columns. 3 of them are: Before After Difference

What are these? I see in this table several queries that have very large differences. For example: Before : 9526592 After: 40.48 Is this indicating that I can get a better index strategy on this statement?

Thanks TPS

asked 16 Jul '13, 14:28

TPS's gravatar image

accept rate: 0%

If an index would definitely help it would have been recommended to you, anway you can try specific queries with the Plan viewer and play around with the introduction of indexes by yourself.

permanent link

answered 17 Jul '13, 05:33

Martin's gravatar image

accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 16 Jul '13, 14:28

question was seen: 2,237 times

last updated: 17 Jul '13, 05:33