agriffin02
New Member
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
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