maria-developers team mailing list archive

Thread
Date

WL#220 New (by Monty): Dissallow table scan in SELECT

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: worklog-noreply@xxxxxxxxxxxx
Date: Thu, 30 Jun 2011 17:28:06 +0000 (UTC)

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Dissallow table scan in SELECT
CREATION DATE..: Thu, 30 Jun 2011, 17:28
SUPERVISOR.....: Monty
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 220 (http://askmonty.org/worklog/?tid=220)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 16 (hours remain)
ORIG. ESTIMATE.: 16

PROGRESS NOTES:



DESCRIPTION:

Add a variable SQL_FORCE_INDEX_USAGE= 0 | 1 | 2

0 is normal.
1 would give an error if you are not specifying a usable index for all tables.
  It would still allow MariaDB to do a table scan if that's the best method.
2 Give an error for any SELECT's that would use a table scan on a normal
  (not internal temporary) table.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)