indexing on column having duplicate values

2014-05-28 Thread Rajeev Prasad
Gurus, I am going to have a big table with lot of records, to expedite searching i wanted to index on a key field (which is numeric value). BUT, there will be records which will have same value for the key field (other columns will be different). so how can i do this? right now, i am getting er

Re: indexing on column having duplicate values

2014-05-28 Thread Reindl Harald
Am 28.05.2014 21:43, schrieb Rajeev Prasad: > I am going to have a big table with lot of records, to expedite searching i > wanted to index on a key field (which is numeric value). BUT, there will be > records which will have same value for the key field (other columns will be > different). >

Re: indexing on column having duplicate values

2014-05-28 Thread Reindl Harald
Am 28.05.2014 22:29, schrieb Rajeev Prasad: > I am using phpMyAdmin, i looked closely and found "index" is this index you > are talking about? (earlier i used "Primary"). surely primary is a uniqe key, honestly consider to read some manuals > My further question is: the index key here is goin

Re: indexing on column having duplicate values

2014-05-28 Thread Rajeev Prasad
(re-sending, i got err from yahoo) thx Reindl, I am using phpMyAdmin, i looked closely and found "index" is this index you are talking about? (earlier i used "Primary"). My further question is: the index key here is going to be epoch system time. I currently have it as integer 10. The table wi

Re: indexing on column having duplicate values

2014-05-28 Thread Reindl Harald
Am 28.05.2014 22:39, schrieb Rajeev Prasad: > (re-sending, i got err from yahoo) your previous message made it off-list to me *don't use reply-all on mailing lists* signature.asc Description: OpenPGP digital signature