It does not have to use an index because you have not supplied row
restriction criteria. An index is being used to relate the two tables.
-Original Message-
From: Daniel Cummings
To: [EMAIL PROTECTED]
Sent: 5/24/04 6:05 PM
Subject: Understanding Explain in 4.1
These are two simple stock
Explain in 4.1
It does not have to use an index because you have not supplied row
restriction criteria. An index is being used to relate the two tables.
-Original Message-
From: Daniel Cummings
To: [EMAIL PROTECTED]
Sent: 5/24/04 6:05 PM
Subject: Understanding Explain in 4.1
These are two
: Understanding Explain in 4.1
Victor-
It's a little misleading. It looks like it's going to do a full table
scan
of the Monday table.
Dan
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 6:18 AM
To: 'Daniel Cummings '; '[EMAIL PROTECTED
These are two simple stock quotes tables that contain a symbol and a close
amount.
Explain
Select Monday.Symbol, Friday.Close, Monday.Close
From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON
Monday.Symbol = Friday.Symbol
Symbol is a VarChar(20) in both