TIP: Click on subject to list as thread! ANSI
echo: paradox
to: ALL
from: KENNETH ULLMAN
date: 1995-07-14 16:42:00
subject: secondary index

is there a rule of thunb or some sort of guide lines you can give me to 
determine when to set up a secondary index for queries?
most of my queries takes about 20+ seconds to run on a 10k database with 
about 500 hits.
Is this average time or high . i'm use 486 - 90 machine.
--- 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™.