How to create index-by table in oracle?

Answer Posted / sourav mukhopadhyay

Create index INDEXNAME
ON table(column-name);

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I find my oracle client driver version?

763


Respected sir, Please send me technical questions related to oracle apps..

1599


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2047


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1455


What are data pump export and import modes?

844


How to connect to a local oracle 10g xe server?

756


What is a package ? What are the advantages of package ?

861


How do we display rows from the table without duplicates?

754


What is a procedure in oracle?

810


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2087


What is logical backup in oracle?

803


Does oracle charge for java?

839


Is it possible to split the print reviewer into more than one region ?

2053


how to join query for one source type is oracle another source type is sql server ?

2228


What is the maximum limit on the number of columns in a table?

785