| Author |
 Topic  |
|
|
mani_1234
Starting Member
India
24 Posts |
 Posted - 09/18/2012 : 00:43:26
|
hi all .
i want to know is there any condition when index creation fails on table ?
though i have taken into consideration that no index created before on it ,data types are supportable for creating index .
i read in internet that when we have read only table u cnt create index on it bt its not true ..
share some other reason
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 09/18/2012 : 01:03:50
|
syntax error ? invalid column name ? access rights ? creating unique index on non-unique data etc ?
KH
Time is always against us
|
 |
|
|
mani_1234
Starting Member
India
24 Posts |
Posted - 09/18/2012 : 01:19:36
|
thanx for your reply ..
is there any internal property that lead to the failure of creation of index?
all the syntz error ,invalid column name are fine ..
what access rights are required for creating it ..please explain more |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
|
|
mani_1234
Starting Member
India
24 Posts |
Posted - 09/18/2012 : 01:38:27
|
no i m not gettng any error for same ..its a kind of R&D that i was given ...bt from yesterday i was not able to find out the reason for it |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
|
|
bandi
Flowing Fount of Yak Knowledge
India
1419 Posts |
|
| |
Topic |
|
guidance
