Home » SQL & PL/SQL » SQL & PL/SQL » INDEX
INDEX [message #335684] Wed, 23 July 2008 05:12 Go to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
I have created one table as emp1 columns are given below and corresponding index


 
EMPNO          
 ENAME          
 JOB            
 MGR            
 HIREDATE       
 SAL            
 COMM           
 DEPTNO         


create index idx_emp1 on emp1(ename);


If i insert some record into the table emp1 the corresponding data value will be inserted into the index also and i want to view that records which is inside the index

can anyone tell me how can i view the index data
Re: INDEX [message #335689 is a reply to message #335684] Wed, 23 July 2008 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Dump the index blocks.
You don't and can't query an index. You have to trust Oracle, it does it.

Regards
Michel
Re: INDEX [message #335705 is a reply to message #335689] Wed, 23 July 2008 06:41 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
Michel,

Dump the index blocks.
means references about the index block if it is so then help me or send any link for that dump.
Re: INDEX [message #335706 is a reply to message #335705] Wed, 23 July 2008 06:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unless you know Oracle internal structure, I think it would be useless to dump the blocks.

Richard Foote once made a presentation named "Oracle B-Tree Index Internals: Rebuilding The Truth", I think you can find it on the Web.

Regards
Michel
Re: INDEX [message #335709 is a reply to message #335706] Wed, 23 July 2008 06:54 Go to previous message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
Thanks Michel
Previous Topic: Left outer joins over a HS link
Next Topic: Help can't get this to work
Goto Forum:
  


Current Time: Sun Dec 11 06:06:00 CST 2016

Total time taken to generate the page: 0.08097 seconds