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

how you create security to reports?

608


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2157


What is cognos reporting tool?

623


----------------Describe DWH Architecture?

1665


How create measures and demensions?

617






-------------What is Coditional Prompting?

1599


What is the difference between set functions and filter function in dimensional data?

2519


How do you Parametermap variables in Quiries?

1786


What is set to be Cognos configuration?

614


2. What functional area you worked on.

1921


What are the advantages of cognos?

582


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1293


Name the types of report?

565


what are the dimensions that you have in your current project?list them?

1646


How can I schedule reports in cognos?

608