Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using combined indexes

Status
Not open for further replies.
Yazster

Yazster

Programmer
Sep 20, 2000
175
CA
I have a database created in Visual Foxpro. Indexes were created, and in one case, an index was created using the contents of 3 separate fields (combined index, ie FIELD1+FIELD2+FIELD3)

Is Crystal Reports able to take advantage of combined indexes? What I need to do is run an outer-join query using three fields from table A, compared to three fields from table b. This works great when running in VB or Visual Foxpro, but in Crystal it's painfully slow.

Any ideas?

Thanks,
Yazster
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top