progress 4gl - I need to my query make it as multiple index how is it is possible -


for each customer no-lock cs-id = "abc" , em-id = "123" ,  vehicle = yes:     display customer.   end.  index  idx1  cs-id  em-id country state   idx2   cs-id vehicle   

my query took idx2 not took multiple index if take both index performance improve.

question : how make query multiple index.

note: condition should same

this article covers multiple index selection in progress

in arcticle mention following:

when selection criteria includes use of and, more 1 index used when components of each index involved in equality matches, , indexes not unique.

in query not specifying country , state don't believe multiple index kick in.

progress not use amount of data in each determine index use. going assume using cs-id, em-id returns less rows compared idx2 using vehicle, force progress use idx1 follows

for each customer no-lock customer.cs-id = "abc" , customer.em-id = "123" , customer.vehicle = yes use-index idx1: display customer. end.


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -