SQL Anywhere 12.0.1.3519

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

TPS
196131320
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

Martin
8.6k116151237
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

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:

×26

question asked: 16 Jul '13, 14:28

question was seen: 540 times

last updated: 17 Jul '13, 05:33