Indexes

[agriffin02]

I having some problems with the performance of retrieving and updating data in Progress. I want to try using indexes because it seems like every time I run a query, it is doing a table scan. Is that right if you aren't explicitly using an Index?

I get a syntax with this statement:
select * from pub.jobhead with(index("pub.jobhead.openjob")) order by JobNum asc;

What is wrong with this?

Thanks

 

[tamhas]

Since you have no selection criteria, of course it needs to read the whole table.

 

[Casper]

To add to that:

with(index("pub.jobhead.openjob")) doesn't force the sql engine to use that index.
It only suggests the sql engine to use that index. But the engine will only do that if the index is present in a list of possible indexes he makes up himself during analyzing the query.

casper.