Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Tue, Jul 10 2007 1:16 PM	Permanent Link
"Johnnie Norsworthy"	If I open a canned SELECT from a table using only indexed fields are they retrieved only from the index file and not the .DAT file? I have some large tables and was curious for speed issues. Thanks, Johnnie
Tue, Jul 10 2007 6:43 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Johnnie, << If I open a canned SELECT from a table using only indexed fields are they retrieved only from the index file and not the .DAT file? I have some large tables and was curious for speed issues. >> No, they are always retrieved from the .dat - the indexes are simply used to locate the desired rows. -- Tim Young Elevate Software www.elevatesoft.com
Tue, Jul 10 2007 7:46 PM	Permanent Link
"Johnnie Norsworthy"	"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:B98DFA2B-8960-48B4-B9C7-7E5EF0D0B129@news.elevatesoft.com... > Johnnie, > > << If I open a canned SELECT from a table using only indexed fields are > they retrieved only from the index file and not the .DAT file? I have some > large tables and was curious for speed issues. >> > > No, they are always retrieved from the .dat - the indexes are simply used > to locate the desired rows. Thanks Tim.