Re: [Axapta-Knowledge-Village] Queries

[Varden Morris]

You are most welcome buddy.                     Varden Morris Senior Developer WellPoint Systems Inc.   Microsoft Gold Certified Partner  (403) 444-5848 direct (403) 444-3900 main   (403) 615-1604  cellwww.wellpoint.ca [EMAIL PROTECTED]Ax Dev <[EMAIL PROTECTED]> wrote:    Thanks Varden,     Great, really a good knowledgable materail it is.      Thanks & Regards,  Harsh Birla   On 12/30/05, Varden Morris <[EMAIL PROTECTED]> wrote:         What is the
 difference between Primary Index and Cluster Index? Where to use these two?     There are two main types of indexes that we can have on a Microsoft SQL Server backend Database. These are normal and clustered indexes. Normal index can be viewed as the index in the back of a book. We first look in the index for a topic. After finding the topic in alphabetical order we also find the page number or address of the topic in the book. We then use the address to easily find the topic. If we did not have this index we would have to search sequentially through the book and the larger the book the greater the effort and time to either find a topic or realize that it does not exist.      This is similar to a normal index in the database where we have the data stored in one file and the index stored in another file in the order specified. The database engine using the index will first look in the index file then retrieve the address of the record that is used to locate the record in the data file.      For clustered index the records in the data file are sorted in the order of the index. We therefore do not have a separate index file from the data file as we have for normal index. You should also note that it is
 only possible to have one clustered index per table, since the records may only be sorted in one order at any time. You can have several normal indexes and one clustered index for each table. Clustered indexes are more efficient since the index is the actual data records and hence you do not need to seek in another file after finding the key.     The Primary Index of a table is the main index that is used to uniquely identify records in it. No duplicated values are allowed in this index and all fields in the index are required. You can designate a clustered or normal index as the primary index. Since the primary index is the main index you should gain optimum performance by designating a
 clustered index for this purpose.     Please note that indexes in general improve performance for search but not for inserts or update, since the overhead of organizing and or writing the index is involved.        Can we define Global Methods in Axapta? If yes then how and where?      
 Yes we can. Look at the Global class. Just write a static method in this class and you will be able to call is anywhere in the application.             What is difference between Axapta Kernel and Axapta Application?In a 3-tier installation Axpata Application is stored on AOS, what about the kernel?      I would say that the kernel is that part of the application that is not exposed to the developer for altering. The behavior of the kernel is encapsulated in the application and is automatically executed as originally intended. For example, when a record is saved the kernel automatically assigns a RECID to the RECID field.      The AOS is a windows service that loads and executes the application in memory on the local computer where it is installed. The application may be placed on a drive on the computer running the AOS or on a network share. harshbirla_cse <[EMAIL PROTECTED]> wrote:   Hi All,I am having some queries. Please write me back with your valuable suggestions:1. What is the difference between Primary Index and Cluster Index? Where to use these two? 2. Can we define Global Methods in Axapta? If yes then how and where?3. What is difference between Axapta Kernal and Axapta Application?In a 3-tier installation Axpata Application is stored on AOS, what about the kernal?Please write me back.Thanks a lotRegards,Harsh                  Varden Morris
 Senior Developer WellPoint Systems Inc.   Microsoft Gold Certified Partner  (403) 444-5848 direct (403) 444-3900 main   (403) 615-1604  cellwww.wellpoint.ca [EMAIL PROTECTED]      Yahoo! ShoppingFind Great Deals on Holiday Gifts at Yahoo! Shopping Sharing the knowledge on Axapta.Visit www.frappr.com/axapta for axapta friends.   SPONSORED LINKS         Business finance course   Business to business finance   Small business finance     Business finance consultant   Business finance magazine   Business finance schools      
 YAHOO! GROUPS LINKS      Visit your group "Axapta-Knowledge-Village" on the web.     To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.     
       
		Yahoo! Shopping 
Find Great Deals on Holiday Gifts at Yahoo! Shopping 





Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.





    


  
  
    SPONSORED LINKS
  
          
                  
            
        Business finance course
      
                      
        Business to business finance
      
                      
        Small business finance
      
              
                        
            
        Business finance consultant
      
                      
        Business finance magazine
      
                      
        Business finance schools
      
              
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.