The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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: 747 times

last updated: 17 Jul '13, 05:33