Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Mar 2012
    Posts
    168
    Thanks
    5
    Thanked 11 Times in 11 Posts

    Binary search & sorting algorithms?

    Fairly quick question here. Been focusing on sort and search algorithms and I was wondering if MySQL databases use binary search to locate data and or a specific sorting algorithm?

    Thanks for any insight!

  • #2
    Master Coder felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, Australia
    Posts
    6,592
    Thanks
    0
    Thanked 644 Times in 634 Posts
    Use EXPLAIN to find out which of the many different ways that SQL can use to find the desired data is being used in a particular situation.
    Stephen
    Learn Modern JavaScript - http://javascriptexample.net/
    Helping others to solve their computer problem at http://www.felgall.com/

    Don't forget to start your JavaScript code with "use strict"; which makes it easier to find errors in your code.

  • #3
    Regular Coder
    Join Date
    Mar 2012
    Posts
    168
    Thanks
    5
    Thanked 11 Times in 11 Posts
    Quote Originally Posted by felgall View Post
    Use EXPLAIN to find out which of the many different ways that SQL can use to find the desired data is being used in a particular situation.
    Wow, had no idea something like that existed. Welp, this makes things fun - thanks!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •