how can you access index
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / raghu
first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename
Is This Answer Correct ? | 1 Yes | 0 No |
Is the primary key a clustered index?
How many clustering indexes can be defined for a table?
What is cursor stability in db2?
What is buffer pool and list some of them?
How to resolve -502 sql code in DB2?
What is lock escalation?
Compare a subselect to a join?
What is the role of schema in the db2 database?
What is the advantage in De-normalizing tables in DB2?
How can you count the number of rows from a table tab?
Can we install 2 different versions of Db2 on same mainframe?
What is a DB2 plan?