dba.stackexchange.com/questions/59347/why-does-mysql-fail-to-use-an-index-effectively-when-limit-offset-is-large

Preview meta tags from the dba.stackexchange.com website.

Linked Hostnames

40

Thumbnail

Search Engine Appearance

Google

https://dba.stackexchange.com/questions/59347/why-does-mysql-fail-to-use-an-index-effectively-when-limit-offset-is-large

Why does MySQL fail to use an index effectively when LIMIT offset is large?

I do not understand when querying 5 rows from a table of 500,000 rows, the following query takes 0.00sec: SELECT id, username FROM Users FORCE INDEX (PRIMARY) ORDER BY id LIMIT 20,5; But querying ...



Bing

Why does MySQL fail to use an index effectively when LIMIT offset is large?

https://dba.stackexchange.com/questions/59347/why-does-mysql-fail-to-use-an-index-effectively-when-limit-offset-is-large

I do not understand when querying 5 rows from a table of 500,000 rows, the following query takes 0.00sec: SELECT id, username FROM Users FORCE INDEX (PRIMARY) ORDER BY id LIMIT 20,5; But querying ...



DuckDuckGo

https://dba.stackexchange.com/questions/59347/why-does-mysql-fail-to-use-an-index-effectively-when-limit-offset-is-large

Why does MySQL fail to use an index effectively when LIMIT offset is large?

I do not understand when querying 5 rows from a table of 500,000 rows, the following query takes 0.00sec: SELECT id, username FROM Users FORCE INDEX (PRIMARY) ORDER BY id LIMIT 20,5; But querying ...

  • General Meta Tags

    2
    • title
      myisam - Why does MySQL fail to use an index effectively when LIMIT offset is large? - Database Administrators Stack Exchange
    • viewport
      width=device-width, height=device-height, initial-scale=1.0, minimum-scale=1.0

  • Open Graph Meta Tags

    6
    • og:type
      website
    • og:url
      https://dba.stackexchange.com/questions/59347/why-does-mysql-fail-to-use-an-index-effectively-when-limit-offset-is-large
    • og:site_name
      Database Administrators Stack Exchange
    • og:image
      https://cdn.sstatic.net/Sites/dba/Img/[email protected]?v=246e2cb2439c
    • twitter:title
      Why does MySQL fail to use an index effectively when LIMIT offset is large?

  • Twitter Meta Tags

    2
    • twitter:card
      summary
    • twitter:domain
      dba.stackexchange.com

  • Link Tags

    10
    • alternate
      /feeds/question/59347
    • apple-touch-icon
      https://cdn.sstatic.net/Sites/dba/Img/apple-touch-icon.png?v=cdcd5ff7b29e
    • canonical
      https://dba.stackexchange.com/questions/59347/why-does-mysql-fail-to-use-an-index-effectively-when-limit-offset-is-large
    • image_src
      https://cdn.sstatic.net/Sites/dba/Img/apple-touch-icon.png?v=cdcd5ff7b29e
    • search
      /opensearch.xml

Links

114