General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
There is an ALTER TABLE command that will let you create a primary key.
>I have a form that inserts a couple of million records into a table from a text file. This process seems to get slower and slower the longer it runs.
>
>I would like to delete the indexes on this table before reading in the data. Hopefully this will speed thinks up.
>
>I found the delete tag command that actually deletes the cdx file. Is there a way to recreate these indexes programmatically when everything is done. I looked at the index command, but I don't think this will work because I need on of the indexes to be primary.
>
>Is there another way to do this?
>
>Thanks
>
>Pat Murphy
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only