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 |
Explain transactions, commits and rollbacks in DB2.
why we go for SPUFI for creating tables or for sql queries?
Where can you declare a cursor in a cobol-db2 program?
What is normalization and what are the five normal forms?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the maximum number of columns in a db2 table?
what is cursor stability?
When can an insert of a new primary key value threaten referential integrity?
Give a brief description of db2 isolation levels?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are the various locks available?
How to resolve -504 sql code in DB2?