On the use of federated Index in mysql pagination Optimization with where condition

if the table table has a federated index (sex, id)
and id itself is the primary key
, does the following sql go to the index?

select * from table where sex="m" order by id limit 1000000,10

my feeling is that according to the execution order of sql
, we should first execute from table where sex="m", to filter out the result set, and then go to order by id, so I don"t feel like I"m going to index
, so I have to

select * from table in (select id from table where sex="m" order by id limit 1000000,10)

is that so?

Mysql mysql-optimized

Mar.16,2021

(1) SQL statement execution order:
SELECT

 FROM          --1
    WHERE    --2
      GROUP BY   --3
        HAVING      --4
           ORDER BY  --5

(2) if select queries only index fields, order by index fields will use the index, otherwise it will be arranged in the whole table;
(3) if there are where conditions, such as where sex='m' order by id, order by will also use the index!

Don't ask in an EXPLAIN, post?

Previous: Express failed to submit the form using ajax. App.post is invalid.

Next: Vsc supports es6 not to report errors.

How do Mysql: select nonclustered index columns, clustered index columns, unindexed columns and * compare performance?
has always thought that index optimization is effective in where is useless in select but it seems that there is a performance difference between select nonclustered index columns, clustered index columns, unindexed columns and select *? ...

Mysql mysql-optimized

Mar.02,2021
Mysql query performance problem, the speed of adding order by is almost 50 times slower.
basic information: The datasheet has almost 10 million pieces of data, using the mycat sublibrary. the indexes in the data table are PRIMARY id AppName (AppName, custidStatus, channel) the table creation statement is as follows CREATE TABLE...

Mysql mysql-optimized msyql-order

Apr.13,2021
MySQL uses in to query. The collection after in is relatively large. How to optimize SQL?
MySQL,select uses in to query. There are about 5000 items in the collection after in. There are many records in this table. The fields in in query are indexed . the original SQL is similar to this SELECT a FROM table WHERE an in ( 1x code 2 ) and o...

Mysql mysql-optimized

Apr.29,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b377fe-34466.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b377fe-34466.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?