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

i have some prob lem to tell me about my self in interview first round ...

2221

What is sql profiling in oracle?

1133

what is not null constraint? : Sql dba

1078

What is the difference between the conventional and direct path loader? : aql loader

1195

How subquery works in sql?

1131

What is output spooling in sql*plus?

1092

What are the benefits of pl sql?

1185

What is the difference between numeric and autonumber?

1041

What are sql ddl commands?

1138

what is oltp (online transaction processing)? : Sql dba

1131

Which are the different character-manipulation functions in sql?

1113

how to use like conditions? : Sql dba

1166

discuss about myisam index statistics collection. : Sql dba

1005

what does the t-sql command ident_current does? : Transact sql

1048

What is full form of rtm?

1056