What is indexing and what are the different kinds of indexing?

What is indexing and what are the different kinds of indexing?
by

1 Answer

Answer :

Indexing is a technique for determining how quickly specific data can be found. Types:
∙ Binary search style indexing
∙ B-Tree indexing
∙ Inverted list indexing
∙ Memory resident table
∙ Table indexing
by

Related questions

What does the "allow indexing" tab mean on facebook?

Description : What does the "allow indexing" tab mean on facebook?

Last Answer : it means if you dont get rid of that tick everybody in the whole world will be able to see what you got!

Have you heard about Facebook's new google indexing?

Description : Have you heard about Facebook's new google indexing?

Last Answer : Yup. It means that anything you allow the public to see about your profile, can be searched via Google by anyone with a mind to find you. (If you make your wall or profile private, Facebook says ... Go to Settings-> Privacy Settings-> Search and uncheck the ticky box that says Allow Indexing. :)

What is the best file indexing/searching utility?

Description : What is the best file indexing/searching utility?

Last Answer : i’ve been using copernic search and it seems to be doing quite well.

How can you positively impact google indexing?

Description : How can you positively impact google indexing?

Last Answer : By not creating new web content.

Spotlight never stops indexing?

Description : Spotlight never stops indexing?

Last Answer : I’ve heard a suggestion is to delete your index file and then let spotlight start a fresh index. Worth a shot. I’m not entirely sure where that is though…

Why sorting requires more memory than indexing ? Explain. ?

Description : Why sorting requires more memory than indexing ? Explain. ?

Last Answer : Sorting requires more memory than indexing. The reason is that sorting does not automatically update the data in the file. This changes the original file. Indexing automatically updates the data in the file. The original file remains unchanged.

What is Indexing ?

Description : What is Indexing ?

Last Answer : Answer : Indexing is the process of sorting records in a specific way without changing the serial number of the input record of the data file.

Why sorting and indexing are not one ?

Description : Why sorting and indexing are not one ?

Last Answer : Sorting and indexing are not the same. This is because sorting the data file in the sorting method changes the serial number of the record in the original data file. But the serial number of the ... file is not updated , but the indexing is updated automatically. So sorting and indexing are not one.

I need to place them in indexing order, Harris George, Harris George E, Harris Georgia

Description : I need to place them in indexing order, Harris George, Harris George E, Harris Georgia

Last Answer : Need Answer

How to use Indexing in mixed expressions?

Description : How to use Indexing in mixed expressions?

Last Answer : Need Answer

How the buckets are stored in predicate indexing? a) Lists b) Stack c) Hashes d) None of the mentioned

Description : How the buckets are stored in predicate indexing? a) Lists b) Stack c) Hashes d) None of the mentioned

Last Answer : c) Hashes

What is meant by predicate indexing? a) All the one kind of facts in one bucket and another kind in other bucket b) Acts like index for facts c) All of the mentioned d) None of the mentioned

Description : What is meant by predicate indexing? a) All the one kind of facts in one bucket and another kind in other bucket b) Acts like index for facts c) All of the mentioned d) None of the mentioned

Last Answer : a) All the one kind of facts in one bucket and another kind in other bucket

In post —indexing the indexing is performed a Before the indirection b. After the indirection c Same time indirection d. — Allof these

Description : In post —indexing the indexing is performed a Before the indirection b. After the indirection c Same time indirection d. — Allof these

Last Answer : b. After the indirection

In post-indexing the contents of the address field are used to access a memory location containing a___ address: Immediate addressing Direct addressing Register addressing ao | None of these

Description : In post-indexing the contents of the address field are used to access a memory location containing a___ address: Immediate addressing Direct addressing Register addressing ao | None of these

Last Answer : Direct addressing

In pre —indexing the indexing is performed_ a. Before the indirection b. After the indirection Same time indirection All of these

Description : In pre —indexing the indexing is performed_ a. Before the indirection b. After the indirection Same time indirection All of these

Last Answer : a. Before the indirection

It is process of elevating website ranking in the unpaid results of search engine. A. Web Indexing B. Search Engine Optimization C. Tracking D. Paid Search Advertising

Description : It is process of elevating website ranking in the unpaid results of search engine. A. Web Indexing B. Search Engine Optimization C. Tracking D. Paid Search Advertising

Last Answer : B. Search Engine Optimization

What do you mean by "social media optimization"?  A. Writing clear content  B. Creating short content which is easily indexed  C. Hiring people to create content for social networks  D. indexing content which easily presents publicity via social networks

Description : What do you mean by "social media optimization"?  A. Writing clear content  B. Creating short content which is easily indexed  C. Hiring people to create content for social networks  D. indexing content which easily presents publicity via social networks

Last Answer : D. indexing content which easily presents publicity via social networks

Which of the following is a structured data store that supports indexing and data queries to both EC2 and S3? a) CloudWatch b) Amazon SimpleDB c) Amazon Cloudfront d) All of the mentioned

Description : Which of the following is a structured data store that supports indexing and data queries to both EC2 and S3? a) CloudWatch b) Amazon SimpleDB c) Amazon Cloudfront d) All of the mentioned

Last Answer : Amazon SimpleDB

What are the different objects that you cannot copy or reference in object groups?

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the Different Optimisation Techniques

Description : What are the Different Optimisation Techniques

Last Answer : The Various Optimisation techniques are a) Execute Plan :: we can see the plan of the query and change it accordingly based on the indexes b) Optimizer_hint :: set_item_property('DeptBlock', ... SQL statements reuse the cursor. f45run module = my_firstform userid = scott/tiger optimize_Tp = No

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What are different Oracle database objects?

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What are the different methods of backing up oracle database ?

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

What are the different kind of export backups?

Description : What are the different kind of export backups?

Last Answer : Full back - Complete database Incremental - Only affected tables from last incremental date/full backup date. Cumulative backup - Only affected table from the last cumulative date/full backup date.

What are different types of images?

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

Can one import/export between different versions of Oracle? (for DBA

Description : Can one import/export between different versions of Oracle? (for DBA

Last Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

What are different types of modules available in oracle form?

Description : What are different types of modules available in oracle form?

Last Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

What are the different styles of activation of ole Objects?

Description : What are the different styles of activation of ole Objects?

Last Answer : In place activationExternal activation

How is link tool operation different bet. reports 2 & 2.5?

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

What are the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

What are the different modals of windows?

Description : What are the different modals of windows?

Last Answer : Modalless windows Modal windows

What are the different display styles of list items?

Description : What are the different display styles of list items?

Last Answer : Pop_listText_listCombo box

What are the different types of Record Groups?

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

What are the different file extensions that are created by oracle reports?

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.