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
Printable View
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