General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How many indexes it too many?
Hi!
I posted a message "Help!...Records Inserted into the table competely lost.." a little while ago relating to this question
but I want to ask another related question:
How many indexes it too many?
The table has 8 out of its 16 columns indexed and only has insert activity in it no deleted, updates.
Is this a performance problem or potential problem here.
I know about Oracle as a DBA and I would deffinetly
critize this number of indexes on a table of this type for insert performance but I have found foxpro indexes to be extremely unstable.
I often have to drop the cdx file and reindex twice a week on this table.
Problem is all the foxpro code does stuff like.
set order to tag blah
seek blahblah
Is this a/the problem???
Next
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