Home » SQL & PL/SQL » SQL & PL/SQL » Index on aTable
Index on aTable [message #246769] Thu, 21 June 2007 17:19 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
1)When you creates an index on a table ,on what basis does the
UNIQUENES column in a user_index table differs?

2)Is there any table where i can and check the details
of index created other than the user_index table

for eg :I wanted to the details of already created an index like the column on which it is defined
Re: Index on aTable [message #246770 is a reply to message #246769] Thu, 21 June 2007 17:22 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
1)When you creates an index on a table ,on what basis does the
UNIQUENES column in a user_index table differs?

Indicates whether the index is UNIQUE or NONUNIQUE

Quote:
2)Is there any table where i can and check the details
of index created other than the user_index table


  
        col$  	              ind$    	     ind_online$
       indpart$ 	    ind_stats$ 	      indsubpart$
       index_histograms      index_stats 	v$object_usage


DBA  	                     ALL  	            USER
dba_indexes 	        all_indexes 	         user_indexes
dba_ind_columns 	all_ind_columns 	user_ind_columns
dba_ind_expressions 	all_ind_expressions 	                                                                                                                                                                                                                                                                                user_ind_expressions


Quote:
for eg :I wanted to the details of already created an index like the column on which it is defined


dba_ind_columns 	all_ind_columns 	user_ind_columns

[Updated on: Thu, 21 June 2007 17:39]

Report message to a moderator

Previous Topic: Cursor question
Next Topic: running Oracle Procedures as a DOS Batch file
Goto Forum:
  


Current Time: Sat Dec 10 20:33:43 CST 2016

Total time taken to generate the page: 0.08072 seconds