i am using sequence numbers to uniquely identify the rows in a table. But the numbers of rows that will be inserted daily will be in the order of thousands .. (1000-3000). So it is possible that the sequence nos get used quickly and the prev data will be overrriden (assuming that all the data is required for some time)
Is there any alternative to using sequences?? Also performance wise will there be any problem in using sequences in this case (I am no goood in DB pls suggest!!)
The sequence tables can go to a very very large number, so even at 100 per day, you shouldn't run out. You can also cache a good number of them at a time, so the performance is better.
The other option is to have the Application determine the next number, in which cas you would have to do a query on the table to determine the highest number already used and add 1 to it.