RE: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do

[Varden Morris]

Yes, Axapta drops the index and rebuild it by sending the necessary commands to the backend database to execute these actions. Once you have created an index in Axapta and it is active the definition will be created in the backend database and you can reindex the database directly without going thru Axapta.
 
Just have it in mind that you create database object for Axapta within Axapta and Axpata sends the necessary backend database commands to the database do execute the action. You should not make any modification to the database definition directly in the backend database because this will lead to inconsistency in the definition between Axapta and the backend database. If you make a modification to a table from the backend database by adding a field or index this should not cause any problem in Axapta but Axapta will not know that these objects exit and will not be able to use them. If you then add the field to the table from Axapta Axapta will alter the table and remove the field if it exists and then and the field with the definition requested from Axapta. If you remove a field or index from Axapta this will cause problems in Axapta when Axapta attempts to use them. If you add a table directly to the backend database and then try to add
 it from Axapta the backend database will throw and error which Axapta will then throw to the user stating that the table already exits in the database.
 
Rebuilding the index from the backend does not change the index definition but recreates the index data from the definition that is done by the database and not Axapta. Axapta just sends the necessary command to the backend database to execute this action.Harry Deshpande <[EMAIL PROTECTED]> wrote:










Hi
 
To add some information (I am not an expert in SQL so I don’t know what are the complete implications) but
 
Reindexing from Axapta drops the indexes completely and then re-create them. However, SQL server will just correct the indexes (as per what I have been told).
 
Regards
 
harry
 


 
 
 
Harry Deshpande 
Senior Consultant 
CGNZ Middle Market Solutions 
Website: www.cgnz.com/middlemarketsolutions 
Ph +64 29 289 9031 
Fax +64 9 358 1018 
 
CGNZ Limited and its predecessor organisations (Cap Gemini Ernst & Young, and Ernst & Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects.  CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the world’s leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices.  Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies.  The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business
 Solutions.  Find out more about what we do at http://www.cgnz.com/middlemarketsolutions 
 
CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ.  
 
CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments. 
 



From: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Friday, 11 March 2005 9:14 a.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do
 

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.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
 
Phone:  (876) - 923 - 6141 Ext. 2226Fax:     (876) - 923 - 5372 
Cell:     (876) - 3833566Email:   [EMAIL PROTECTED]
            [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. Sharing the knowledge on Axapta. __________________________________________________Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 


Sharing the knowledge on Axapta.








Yahoo! Groups Sponsor


  ADVERTISEMENT 












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.