Viewing 6 posts - 1 through 6 (of 6 total)
Calvin,
I went researching and came across some notes about reorganizing index pages so they perform more efficiently, which is to run a defrag. Also, the root cause of the...
December 10, 2003 at 10:39 am
Ok, now I understand better, Thanks. However, the two index tables are setup with PKs, that's why I do not understand how the data duplicated and why creating new...
December 10, 2003 at 5:29 am
Yes, there were duplicates in the tables. A quick workaround wwas to clear the tables, now I need to reindex. Thanks for your responses, it helped. I'll look...
December 9, 2003 at 9:27 pm
There were two index tables. A processes was run to update the tables from another system. According to our vendor, they indicated the two index tables were out...
December 9, 2003 at 1:42 pm
I never look up first, I treat these questions as test questions to find out how much I do know to prepare myself for the exam.
December 9, 2003 at 6:18 am
No research, just remembered that when you want to allow users access to specific data, building views is the way to go.
quote:
Although...
December 9, 2003 at 6:12 am
Viewing 6 posts - 1 through 6 (of 6 total)