dms@fciva.FRANKLIN.COM (Douglas M. Stevens) (12/24/90)
We are using Unify 4.3 and ACCELL and SQL. We would like to be able to force ACCELL and SQL to use a specified btree. We have a table set up with the following fields: event Registration Number This table has about 200,000 records. There may be multiple events per registration number. I have a btree set up on event. When I do an SQL select on just one event for example: select * from events where event = 'FX' / The selection is very quick, but when I due a selection on multiple events for example: select * from events where event in <'FX','FP','FG' > / SQL does not use the btree and the selection takes 30 to 50 times as long as if I broke this into 3 SQL statements. Is there any way I can force SQL to use the btree I have set up? ACCELL appears to be even more brain damaged. If I take the single SQL select and put it in an SQL SET select statement ACCELL does not use my btree. Doug Stevens Franklin Mortgage Capital uunet.uu.net!fciva!dms