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'

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.

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

Answer / raghu

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

What is a dbrm in db2?

0 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

Can we insert update delete in view?

0 Answers  

---

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

What is ibm db2 connect?

0 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

Explain packages.

0 Answers  

---

What is meant by isolation level?

3 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---