What is indexing how many types?

Answers were Sorted based on User's Feedback



What is indexing how many types? ..

Answer / guest

Indexing is a technique to add or search for particular data
from database.
Regarding the types of indexing I'm a little confused coz
i dint find 32 types but a few of them are:
. primary key index:
.unique index
.bitmap index
.hash index
.function based index
.Virtual index
. Binary Search style indexing
. B-tree indexing
. Inverted list indexing
. Memory List indexing
. Table indexing

and/or
>clustured
>unclustured

Is This Answer Correct ?    12 Yes 6 No

What is indexing how many types? ..

Answer / umesh kumar sharma

Indexing is use to improve the performance of database. it
has 32 types of indexing in each table

Is This Answer Correct ?    12 Yes 8 No

What is indexing how many types? ..

Answer / ramse

Umesh,

can u please explain how the intexing actully works and
name of diffrent types of indexing.

Is This Answer Correct ?    9 Yes 9 No

Post New Answer

More PHP Interview Questions

What is $_ request in php?

0 Answers  


Tell me how is it possible to remove escape characters from a string?

0 Answers  


How to invoke a user function?

0 Answers  


I created a new joomla module for administrator. when am going to install this, it is going "joomla/modules" path. but, i want to install this in the "joomla/administration/modules" path.

2 Answers  


<?php /** * @version 1.0 $ * @package HelloWorld * @copyright (C) 2005 Andrew Eddie * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL */ /** ensure this file is being included by a parent file */ defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' ); ?> <?php $database =& JFactory::getDBO(); //$sql = 'SELECT name, username FROM #__users'; $sql="select a.id, a.title, a.introtext, a.created_by, a.created from jos_content a, jos_content_frontpage b where a.id=b.content_id and b.ordering='2'"; $database->setQuery( $sql ); $user = NULL; $user = $database->loadObject(); //echo 'Name: ' . $user->name . '<br />'; echo '<h1>' . $user->title . '</h1><br />'; //echo 'Username: ' . $user->username; echo ' ' . $user->introtext; i write this and fetch the result from the database the result is The Intranet is up and working ! Our intranet is up and working and should be accessible from both Mumbai and NOIDA. As you will notice, this template, look & feel is not in line with our corporate indentity but we chose the route of "form-follows-funtion" In the first phase, we are rolling out functionality that is critical to all of us - Policies and How-to documents. In subsequent phases, we will be launching other features. Keep watching this space for more details i want to see only 4 line of top then how this may done

0 Answers   Infovision,






What is properties of class?

0 Answers  


Tell me how can you pass a variable by reference?

0 Answers  


How to check an element is exists in array or not in php?

0 Answers  


what is constructor

0 Answers  


How can you count number of parameters given in a URL by POST method?

5 Answers  


What is composer install?

0 Answers  


Where are php configuration settings stored?

0 Answers  


Categories