ubject: RE: 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 Cumm
27;
Subject: RE: Understanding 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
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
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 ta
