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

How to rename a column in the output of sql query?

998

What does 0 mean in sql?

910

what is the use of double ampersand (&&) in sql queries?

1114

Describe sql comments?

959

What are the types of functions in sql?

965

What is the purpose of design view?

948

How insert into statements in sql?

1007

What is sql profiling in oracle?

992

what are different types of keys in sql?

1063

Why is stored procedure faster than query?

906

what is myisam? : Sql dba

999

Can we create index on primary key?

911

What is error ora-12154: tns:could not resolve the connect identifier specified?

1013

what are the advantages of using stored procedures? : Sql dba

1058

Why trigger is used in sql?

913