Interested to Buy Any Domain ? << Click Here >> for more details...
how can you access index
- 4 Answers
- 9642 Views
- IBM, Tech Mahindra, I also Faced
- E-Mail Answers
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 |
What is the SQL Communications Area and what are some of its key fields?
pls tell me abt the normalization five types....
What is ibm db2 database?
How to insert more than one record using insert?
What keyword does an SQL SELECT statement use for a string search?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
How to select the duplicate rows from a table?
What is DB2 (IBM Database 2)?
How does one remove entries from the SCT02 table?
What is cascading rollback?
what is the difference between normal select query and currosor
How to find the maximum value in a column in the db2 database?
COBOL 
