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

Mention what does plv msg allows you to do?

1107

What is substitution variable?

1048

What is sql constant?

1025

Can I create table without primary key?

997

Is sql sequential or random?

1028

What does an inner join do?

1176

Do foreign keys improve performance?

1020

How do I create a sql database?

993

What is the difference between count 1 and count (*) in a sql query?

985

How to process query result in pl/sql?

1125

what is a trigger in mysql? : Sql dba

1144

What is normalization in sql?

1009

What are crud methods?

1025

What is indexing oracle sql?

1097

What is cold data?

951