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&q




















14 comments









Read more




























PHP code for finding distinct elements common to all rows of a matrix in O(n) time complexity












By
























<?php  class Matrix{ /** •@param 2D array $matrix • •Prints distinct elements common to all rows of the matrix */          public static function getDistinctElementsCommonToAllRows($matrix){                 // A hash map to store count of elements                  $hashmap = array();                 $selectedHash = array();                 $rows = count($matrix);                 $cols = count($matrix[0]);                                                   for ($i = 0; $i < $rows; $i++) {                          // Increment the count of first                          // element of the row                         if(array_key_exists($matrix[$i][0],$hashmap)){                                         $hashmap[$matrix[$i][0]] = $i+1;                          }                          // Starting from the second element                          // of the current row                          for ($j = 1; $j < $cols; $j++) {                                          // If current ele




















Post a Comment









Read more




























PHP code for Implementing LRU cache. 












By
























<?php interface LRUCache{          /**         •@param string $key         •@param string $value         •@return bool $result          •          •Stores value against the key in the cache */         public function insertIntoCache($key,$value);           /**         •@param string $key         •@return string $value         •Gets the value of a key from the cache */          public function getFromCache($key);           /** Purge the entire cache */          public function purgeCache();           /**         •@return int $count         •Gets the number of successful cache hits so far */          public function allCacheHits();           /**         •@return int $count         •Gets the number of unsuccessful cache hits so far          **/                  public function allCacheMissed();  }   class Cache implements LRUCache{          // int the max number of elements the cache supports         private $capacity;         // Array representing a naive hashmap (TODO needs to pass t




















Post a Comment









Read more