In my database there are 3 tables. Like below
Table1:
Doc No (PK) (text type)
Title
Unit
Table2:
Transno (PK) (text type)
Date
Table3:
Doc no (FK) (text type)
Trans no (FK) (text type)
page
In table 1, I selected “docno” field as primary key. And value of “docno” field is text similarly to below
“Dw-999-1340-0001” (some times text value is more than of 50 characters).
But database is slow.
Now I do not know for repairing design I have to add another field to my tables? For example
Table 1:
Docid (PK) auto number
Doc no
Title
Unit
Now if I have to add auto numbers fields to my 3 tables, what I have to do with previous records because each table has more than 20000 records and they are related. I do not know how I have to update that?
Please help what I should do for repairing.