What does Index scan (all rows) mean?

Index Scan Scan MYTable using index FK_1 (all rows)

Will this mean, that SQLA uses the foreign key but will still read all rows of the table?

optimizer

asked 30 Oct '12, 06:45

Martin
9.1k●131●170●257
accept rate: 14%

Is that an IndexOnly scan (i.e. one that would not need to read additional table pages)?

(30 Oct '12, 07:28) Volker Barth

Replies hidden

no, it will have to read also non indexed columns, anyway the restriction through the index would already restrict the rows which have to be visited at all.

(30 Oct '12, 08:24) Martin

flat view

Be the first one to answer this question!

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

optimizer ×28

question asked: 30 Oct '12, 06:45

question was seen: 1,726 times

last updated: 30 Oct '12, 08:24

SAP SQL Anywhere

What does Index scan (all rows) mean?

Follow this question

Related questions