title: What is the algorithm for query search in the database?
body: <p>Good day everyone, I'm currently doing research on search algorithm optimization.</p>
  
  <p>As of now, I'm researching on the Database.</p>
  
  <p>In a database w/ SQL Support.</p>
  
  <p>I can write the query for a specific table.</p>
  
  <ol>
  <li>Select Number from Table1 where Name = "Test";</li>
  <li>Select * from Table1 where Name = "Test";</li>
  </ol>
  
  <p>1 searches the number from Table1 from where the Name is Test and 2 searches all the column for name Test.</p>
  
  <p>I understand the concept of the function however what I'm interested in learning what is the approach of the search?</p>
  
  <p>Is it just plain linear search where from the first index until the nth index it will grab so long as the condition is true thus having O(n) speed or does it have a unique algorithm that speeds its process?</p>