how can you access index

Answers were Sorted based on User's Feedback



how can you access index..

Answer / mani

After creating index by using CREATE command
CREATE UNIQUE INDEX IDX_EMP ON EMPLOYEE(EMP_ID)

To retreive index:

SELECT INDEX_NAME FROM USER_INDEX WHERE TBNAME='EMPLOYEE'

Is This Answer Correct ?    4 Yes 1 No

how can you access index..

Answer / pandu

first of all create index
create index<indexname> on <tablename>(<columnname>);
after that we have to access to that by
Select * from <indexname>


Correct me is am i wrong...
Thank You.

Is This Answer Correct ?    5 Yes 3 No

how can you access index..

Answer / ashok kumar

we generally use the folling query for create index

CREAT INDEX <index name> on <table name>(cols1,cols2,...)

for accessing columes :

SELECT ENAME FROM EMP
WHERE cols1 and cols2

Is This Answer Correct ?    1 Yes 0 No

how can you access index..

Answer / raghu

first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

Is the primary key a clustered index?

0 Answers  


How many clustering indexes can be defined for a table?

2 Answers  


What is cursor stability in db2?

0 Answers  


What is buffer pool and list some of them?

0 Answers  


How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,






What is lock escalation?

2 Answers  


Compare a subselect to a join?

1 Answers  


What is the role of schema in the db2 database?

0 Answers  


What is the advantage in De-normalizing tables in DB2?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


What is a DB2 plan?

8 Answers  


Categories