what are indexes..how many types of index's are there and
what are they?




Answers were Sorted based on User's Feedback



what are indexes..how many types of index's are there and what are they?..

Answer / rudrab123

An index is a listing of keywords accompanied by the
information of location of the subject.
in a SQL statement, if there is no Where clause then there
is no index.

In Oracle 8i,
there are 4 types of indexes .They are:-
1.B-Tree Index
2.Bitmap Index
3.Unique index
4.Function based index.

Is This Answer Correct ?    9 Yes 1 No

what are indexes..how many types of index's are there and what are they?..

Answer / rudrab123

Answer 1 is not he basic function of Index in Oracle or any
databse.
Generally speaking,attaching index to a column in a table,
information of the location of the different values in the
indexed column is also provided.This address is like the
pointer varible in C,and in SQL it is called ROWID(a
pseudocolumn).Let us see he example ....

SQL>select * from students
where id=123;
Students is a databse table and ID is the column in the
table on which we create the index.

On execution of the above query, at first, the ROWID
corresponding to id=123 in students table is found.From
this rowid, the index value for the row of data which is
pointed to by ROWID is found(in very less time).And so the
row is idenified and the entire row data is displayed.
The above serach process is specifically called "TABLE
ACCESS FULL(USING ROWID)).

Is This Answer Correct ?    3 Yes 2 No

what are indexes..how many types of index's are there and what are they?..

Answer / guest

when queries are run against a DB,an index on that DB
basically helps in the way the data is sorted to process
the query for faster data retievals.

There are basically two types of indexes that we use in SQL
Server. Clustered and the Non-Clustered.

Is This Answer Correct ?    6 Yes 6 No




what are indexes..how many types of index's are there and what are they?..

Answer / bhargav kesavan

Indexes are used to do a faster search. i.e; easy way to
retrive data.

There are two types are indexes:
1> B-Tree Indexes.
2> Bitmap indexes.

Is This Answer Correct ?    1 Yes 1 No

what are indexes..how many types of index's are there and what are they?..

Answer / ted

There are four types index:

1)Bitmap index
2)Dense index
3)Sparse index
4)Reverse index

Is This Answer Correct ?    1 Yes 1 No

what are indexes..how many types of index's are there and what are they?..

Answer / a.brahmam

indexes 5 tyeps
1.B-Tree index:-->in oracle by default index is called B tree index.
2.Bit map index:--->in oracle Bit map index is used to data warehouse applications generally Bit map index created low cardinality columns.
3.function based index:--->B tree index extension of the function based index.
in B tree indexes two type this are
4.Unique B tree index in oracle by default automatically created.
5.Non-Unique B tree index in oracle by default manually created.

Is This Answer Correct ?    0 Yes 0 No

what are indexes..how many types of index's are there and what are they?..

Answer / test

Index simply means sorting of data. Let u stake an example :

EmpID Name
1 A
6 B
5 C
9 D
...
...
2 ZZ

Now if we create index (Talking about btree index) on EmpId
it means creating a segment with the following in sorted
order
EmpId Rowid
1 <some value>
2 ....
5 ...
6 ...
...

Now if we want to search with EmpId, it will do a binary
search and get the rowid in few searches

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More Oracle General Interview Questions

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  


how to truncate date and get only time part 9:20:00

5 Answers  


Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,


1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,


Give the Types of modules in a form?

1 Answers  






Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

0 Answers   TCS, Oracle,


I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  


Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,


What is dictionary cache ?

2 Answers  


What are inner join and outer join?

3 Answers  


Can a field be used in a report without it appearing in any data group ?

4 Answers   Oracle,


Does a Before form trigger fire when the parameter form is suppressed ?

1 Answers   Oracle,






Categories