index syntax ----------------- create index index_name on table

What is the criteria while applying index to any column on
any table.

Question Posted / vijay_1994

Answer Posted / vijay_1994

index syntax
-----------------
create index index_name on table_name (column_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between sum and count in sql?

528

is mysql query is case sensitive? : Sql dba

564

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

601

Is record in oracle pl sql?

533

how to extract a unit value from a date and time? : Sql dba

556

What is left inner join in sql?

519

what is the difference between primary key and unique key? : Sql dba

531

What is sql rowcount?

559

What are the advantages of sql? Explain

650

Why do we need databases?

567

How do I edit a stored procedure?

556

What is pragma in sql?

622

What is the size of partition table?

553

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

755

What operating systems are supported by oracle sql developer?

520