Path: utzoo!attcan!utgpu!news-server.csri.toronto.edu!clyde.concordia.ca!thunder.mcrcim.mcgill.edu!snorkelwacker.mit.edu!apple!usc!wuarchive!uunet!fciva!dms
From: dms@fciva.FRANKLIN.COM (Douglas M. Stevens)
Newsgroups: comp.databases
Subject: UNIFY/ACCELL SQL
Summary: Selecting btree's in ACCELL/SQL
Keywords: UNIFY ACCELL SQL
Message-ID: <563@fciva.FRANKLIN.COM>
Date: 23 Dec 90 19:23:53 GMT
Reply-To: dms@fciva.UUCP (Douglas M. Stevens)
Organization: Franklin Mortgage Capital Corp., McLean, Va
Lines: 31


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