Hi Padmaja
You are correct, index is use to search a table in a more efficient way. ReIndex is use to rebuild the indexes on tables. An index may be damaged or become inefficient after several deleting, updating and adding of records to a table. Rebuilding will solve these problems.
I have a personal experience with a table where my Axapta client hangs up each time I tried to update a record in the table. After re-indexing the table the problem went away.
Varden Morris
J. Wray & Nephew Ltd. - Group I.S.
Phone: (876) - 923 - 6141 Ext. 2226
Fax: (876) - 923 - 5372
Cell: (876) - 3833566
Email: [EMAIL PROTECTED]
Padmaja Iyingar <[EMAIL PROTECTED]> wrote:
Hi,Admistration -Perioidic - SQL Admi - Index Actions - Reindex.What does Reindex do exactly?.I thought Index is used for better Searching the records in the Tables.Any help????.-Padmaja
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
