The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
196101220
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.6k114149237
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:

×25

question asked: 16 Jul '13, 14:28

question was seen: 455 times

last updated: 17 Jul '13, 05:33