how can you access index

Question Posted / satheesh

4 Answers
8055 Views
IBM, Tech Mahindra, I also Faced
E-Mail Answers

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