| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| 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™.