What is Index?

Answer Posted / g.arangaraj

Index is one of the databse object.it is used to quickly
locate the particular record.

i.e.if a table contains thousand's of record, in which
retrieving the particular record is difficult.so if we
create index in primary key column, we can retrieve
particular record very soon. so we can save the time.

ex.create index indexname for tablename of columnname.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the components of the report studio?

638


What is meant by Reportstudio shortcut?

1729


What is a Datastore in Cognos?

801


How security is concerned with Reportnet? Explain its implementing steps.

1614


What are the different types of reports present in cognos?

572






Explain the different types of views used in cognos.

510


Can you define pivot?

543


How to join multiple db in catalog?

571


What is the function of model design accelerator?

539


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1977


What do you understand by user class in cognos?

536


What is set to be cardinality?

642


------------------What is Inline Query?

1794


---------------Describe OLAP Reporting and RDBMS Reporting?

1667


hi friends pls forward impropmtu interview question

1687