We have a table for stats in sql server 7.0. The data stored in this table is never queried by the user.
It stores the fields user_id, form_id,date_created.
Record is inserted into this table each time a form is clicked. This table is used only for analyzing the data. At present we have clustered index on user_id,form_id but, no primary key. Is it a good design practice to have a table without primary key?. user_id, form_id is not unique.
Clustered index is created to avoid hotspots. What is the overhead on reorganizing data for clustered index compared to hotspots.
thanks,
Kavya