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 does myisamchk do? : Sql dba

966

Who is the owner of mysql database?

1003

what happens if you no create privilege in a database? : Sql dba

941

Mention what is the use of function "module procedure" in pl/sql?

1010

how many values can the set function of mysql take? : Sql dba

935

Can you skip header records while loading? : aql loader

976

What does the acronym acid stand for in database management?

986

What is pls integer?

987

Can we insert data into materialized view?

899

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

993

What are %type and %rowtype for?

1014

What is a sql select statement?

996

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

1117

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2112

What are the types of sql commands?

1025