TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALL
from: KENNETH ULLMAN
date: 1995-08-19 16:55:00
subject: queries in scripts and 2nd indexes

I have a query that is embedded in a scripts. The query has several 
parameters to query on (one table is involved).  Is there a way to design a 
2nd index to speedup to processes? I have a query, also in a script that list 
all transactions that were entered today. The process seems to get longer and 
longer each day. I've tried to define a secondary index on date but has not 
helped much. What am I doing wrong?
--- FLAME v1.1
---------------
* Origin: HAL-PC - (713)963-4100 (1:106/4100)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.