What is indexing how many types?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is $_ request in php?
Tell me how is it possible to remove escape characters from a string?
How to invoke a user function?
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.
<?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
What is properties of class?
Tell me how can you pass a variable by reference?
How to check an element is exists in array or not in php?
what is constructor
How can you count number of parameters given in a URL by POST method?
What is composer install?
Where are php configuration settings stored?