Skip to main content

What are the effects of indexing on database tables?

Image
By
The working of Index in database tables is the same as index work in a Text Book. It will help to browse the desired content faster in a book. we use to see the index on the first page then we check the page where it is in the book and then we directly come to that page, instead of going through all pages.

Now databases, same happen with tables, if you are applying select query on the table, it will also check for the index and then return you the required field. It will return the field faster on which index is applied.
Or in language,
  • we can say that the index one query will execute faster instead of the non-indexed one.
  • Join will execute faster on indexed one.
eg- Consider a Table Product with `id` as Primary Key
  •  id
  • name
  • price
  • category_id 
  • location_id           
    Table Info-

Now  Applying Index on category_id 



SELECT category_id FROM product WHERE category_id='5';




SELECT category_id FROM product WHERE location_id='10';




First one will excute faster than the second one.



















Labels:






























Comments











Post a Comment




















Popular posts from this blog



















Code for Mail in PHP












By
























  PHP mail function and mail configuration in  XAMPP  and sending mail is done from sendmail through localhost. I hope it will help you.   mail() function     <? php  $to      =  'dubeynitish22@hotmail.com' ;  $subject =  'Test' ;  $message =  'Hello' ;  $headers =  'From: webmaster@example.com'  .  "\r\n"  .      'Reply-To: webmaster@example.com'  .  "\r\n"  .      'X-Mailer: PHP/'  .  phpversion ();     if (! mail ( $to ,  $subject ,  $message ,  $headers )){   echo "Error !!" ;  } else {   echo "Email Sent !!" ;  }  ?>     2. php.ini configuration (For SEND-MAIL)   [ mail function ]  ;  For  Win32  only .  ;  http : //php.net/smtp  ; SMTP = localhost  ;  http : //php.net/smtp-port  ; smtp_port = 25     ;  For  Win32  only .  ;  http : //php.net/sendmail-from  ; sendmail_from =  me@example . com     ;  For  Unix  only .   You  may supply arguments as  well ( default :  "sendmail -t -i...




















14 comments









Read more




























What Make Facebook page load faster ?












By
























  Facebook has a “ Lazy Loading ” system they call “ BigPipe ” that helps the pages load fast. Facebook breaks each page down into sections they call “ Pagelets” , and using Javascript only load the most important Pagelets first then load the less important ones shortly afterward.   And pipeline them through several execution stages inside web servers and browsers, as the modern microprocessor do to serve the various request in an order to increase the productivity.   Big Pipe is totally implemented in PHP and javascript.   By loading and rendering the main page structure first with minimal info on it, the page appears to load quicker than having to wait for a complete page to download and then render.     To exploit the parallelism between web server and browser, BigPipe first breaks web pages into multiple chunks called pagelets. Just as a  pipelining microprocessor  divides an instruction’s life cycle into multiple stages (such as “instruction fetch”, “instruction decode”, ...




















2 comments









Read more




























Write a function that checks if a given word stored in a doubly linked list is a palindrome.












By
























<?php  class Node {          public $value;          public $next = null; // next node          public $prev = null; // previous node          public function __construct($value) {                 $this->value = $value;         } }  class Palindrome {  /** •@param string $word •@return bool */          public static function isPalindrome($head, $tail){                                  if ($head == null)                           return true;                                     while ($head != $tail){                         if ($head->value != $tail->value)                                   return false;                                     $head = $head->next;                          $tail = $tail->prev;                   }                    return true;         } }  $head = new Node(1);  $firstNode = new Node(2);  $secondNode = new Node(3); $tail = new Node(4);  $head->next = $firstNode; $firstNode->prev = $head;  $firstNode->next = $secondNode;...




















Post a Comment









Read more