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
Post a Comment