Thread: How to create an index on a column while creating table

Hi Friends..

Can anyone tell me, how to create an index on a column while creating the table (i.e in a create table statement) without using primary or unique key constraints

indexes are created separately as per the requirment.
not along with create table command.

It is not possible to create a index for a normal column at creation
but
Yes you can create for primary and unique key but its of no use the database define index for the 2 keys automaticly at runtime