Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36041

optimizer uses a poor index for select with STATEMENT SQL_SELECT_LIMIT

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.8, 10.11.11, 11.4.5
    • 11.4
    • Optimizer
    • None
    • 11.4.5-MariaDB-deb12
      11.4.5-MariaDB-ubu2004

    Description

      CREATE TABLE `TestData` (
      		 
        `DatID` int(11) NOT NULL AUTO_INCREMENT,
      		 
        `CustomerID` int(11) DEFAULT NULL,
      		 
        `DatOrdDt` datetime NOT NULL,
      		 
        `DatMStamp` timestamp(3) NOT NULL,
      		 
        PRIMARY KEY (`DatID`),
      		 
        KEY `ITTDatOrdDt` (`DatOrdDt`),
      		 
        KEY `ITTDatMStamp` (`DatMStamp`),
      		 
        KEY `IdxFkTTCustomerID` (`CustomerID`)
      		 
      ) ENGINE=InnoDB AUTO_INCREMENT=9392015 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

      The table contains approximately 9,000,000 rows. CustomerID has about 1,500 different values with unequal frequency. DatMStamp has been relatively continuous from 2009 to the present, and DatOrdDt is similar, with a few outliers that are older and in the future.

      When the condition is set on DatOrdDt and order by to DatMStamp, or vice versa, and use "SET STATEMENT SQL_SELECT_LIMIT = maxRows FOR" the select runtime is over 16 seconds, but not for all CustomerID.

      ANALYZE TABLE was done.

      ANALYZE TABLE TestData PERSISTENT FOR COLUMNS () INDEXES (ITTDatOrdDt, ITTDatMStamp, IdxFkTTCustomerID);

      Here is an example.

      I can provide a tabledump (bzip2 50 MB) for testing purposes to reproduce and investigate the error, as well as select results for all customers.

      CustomerID Milliseconds total maxRows fetched SQL explain id select_type table type possible_keys key key_len ref rows Extra
        5607 9393764 0 9393764 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData 1 SIMPLE TestData ALL         9393764  
      74 59 22373 0 22373 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332  
      74 57 22373 26847 22373 SET STATEMENT SQL_SELECT_LIMIT = 26847 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332  
      74 61 22373 0 22373 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 ORDER BY DatOrdDt 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 143 22373 26847 22373 SET STATEMENT SQL_SELECT_LIMIT = 26847 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 ORDER BY DatOrdDt 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 61 22373 0 22373 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 ORDER BY DatMStamp 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 112 22373 26847 22373 SET STATEMENT SQL_SELECT_LIMIT = 26847 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 ORDER BY DatMStamp 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 58 22367 0 22367 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 61 22367 26840 22367 SET STATEMENT SQL_SELECT_LIMIT = 26840 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 75 22367 0 22367 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 113 22367 26840 22367 SET STATEMENT SQL_SELECT_LIMIT = 26840 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 63 22367 0 22367 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 111 22367 26840 22367 SET STATEMENT SQL_SELECT_LIMIT = 26840 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 49 6 0 6 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 51 6 16 6 SET STATEMENT SQL_SELECT_LIMIT = 16 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 50 6 0 6 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 50 6 16 6 SET STATEMENT SQL_SELECT_LIMIT = 16 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 51 6 0 6 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 16301 6 16 6 SET STATEMENT SQL_SELECT_LIMIT = 16 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData index ITTDatOrdDt,IdxFkTTCustomerID ITTDatMStamp 6   3315 Using where
      74 59 22373 0 22373 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 59 22373 26847 22373 SET STATEMENT SQL_SELECT_LIMIT = 26847 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 62 22373 0 22373 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 111 22373 26847 22373 SET STATEMENT SQL_SELECT_LIMIT = 26847 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 62 22373 0 22373 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 111 22373 26847 22373 SET STATEMENT SQL_SELECT_LIMIT = 26847 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 49 0 0 0 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 61 0 10 0 SET STATEMENT SQL_SELECT_LIMIT = 10 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where
      74 51 0 0 0 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 15934 0 10 0 SET STATEMENT SQL_SELECT_LIMIT = 10 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData index ITTDatMStamp,IdxFkTTCustomerID ITTDatOrdDt 5   2072 Using where
      74 51 0 0 0 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      74 50 0 10 0 SET STATEMENT SQL_SELECT_LIMIT = 10 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 74 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 45332 Using where; Using filesort
      87 56 19612 0 19612 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702  
      87 56 19612 23534 19612 SET STATEMENT SQL_SELECT_LIMIT = 23534 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702  
      87 60 19612 0 19612 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 ORDER BY DatOrdDt 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 108 19612 23534 19612 SET STATEMENT SQL_SELECT_LIMIT = 23534 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 ORDER BY DatOrdDt 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 59 19612 0 19612 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 ORDER BY DatMStamp 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 108 19612 23534 19612 SET STATEMENT SQL_SELECT_LIMIT = 23534 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 ORDER BY DatMStamp 1 SIMPLE TestData ref IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 57 19384 0 19384 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 60 19384 23260 19384 SET STATEMENT SQL_SELECT_LIMIT = 23260 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 67 19384 0 19384 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 108 19384 23260 19384 SET STATEMENT SQL_SELECT_LIMIT = 23260 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 70 19384 0 19384 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 109 19384 23260 19384 SET STATEMENT SQL_SELECT_LIMIT = 23260 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 51 228 0 228 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 49 228 273 228 SET STATEMENT SQL_SELECT_LIMIT = 273 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 49 228 0 228 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 52 228 273 228 SET STATEMENT SQL_SELECT_LIMIT = 273 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 50 228 0 228 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 51 228 273 228 SET STATEMENT SQL_SELECT_LIMIT = 273 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatOrdDt >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatOrdDt,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 58 19384 0 19384 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 57 19384 23260 19384 SET STATEMENT SQL_SELECT_LIMIT = 23260 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp < '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 61 19384 0 19384 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 108 19384 23260 19384 SET STATEMENT SQL_SELECT_LIMIT = 23260 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 61 19384 0 19384 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 109 19384 23260 19384 SET STATEMENT SQL_SELECT_LIMIT = 23260 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp < '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 50 228 0 228 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 50 228 273 228 SET STATEMENT SQL_SELECT_LIMIT = 273 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp >= '2025-01-07 00:00:00' 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where
      87 54 228 0 228 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 53 228 273 228 SET STATEMENT SQL_SELECT_LIMIT = 273 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatOrdDt 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 52 228 0 228 SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort
      87 52 228 273 228 SET STATEMENT SQL_SELECT_LIMIT = 273 FOR SELECT DatID, CustomerID, DatOrdDt, DatMStamp FROM TestData WHERE CustomerID = 87 AND DatMStamp >= '2025-01-07 00:00:00' ORDER BY DatMStamp 1 SIMPLE TestData ref ITTDatMStamp,IdxFkTTCustomerID IdxFkTTCustomerID 5 const 39702 Using where; Using filesort

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            svh Stefan van Hasselt
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.