Results 1 to 6 of 6

Thread: How to manage SQL Server indexes

  1. #1
    Join Date
    Feb 2010
    Posts
    570

    How to manage SQL Server indexes

    See as per my knowledge index is based on the table as a base for database objects. The index also holds the index of columns for sorting the table and record the index listed in the database table in the physical storage location of data in the table to achieve the sort of logic. Through the index, I can speed up the data query speed and reduce system response time; can make the connection between the table and the table faster. But, I want to know how to do this mean how to manage SQL Server indexes or what are the points should be considered while building the index.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Re: How to manage SQL Server indexes

    When the index built in the record of the table to add, delete, modify operation, the database should be re-adjust the index. This work will complete the database automatically, but it needs to consume server resources. When the data in the table the more of this the more resources consumed. Index is a database of real objects, so each index will occupied by a certain degree of physical space. If the index more, not only will take up a lot of physical space, but will also affect the operational performance of the entire database.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Re: How to manage SQL Server indexes

    Take care about the query means in the query; if we do not follow a field to query, then build an index in this field is a waste. For instance, now has a staff information table, we may accord staff numbers, staff names, or of origin, to query employee information. However, we often do not go according to identity card numbers of queries. Although ID number is unique, at this point, even in this field to create an index, nor can improve the query speed. On the contrary, an increase of system maintenance time and take up system space.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Re: How to manage SQL Server indexes

    In the information management system often required by the scope to check records of certain transactions. Such as ERP systems, often need to query the month shipments of sales orders and sales, which required by the date range to query transactions. If stock does not find the time, we also need a period of time and out of stocks, such as May 1 to December 3 in stock trading and so on. For these needs within prescribed limits, rapid or frequent query data columns, the need for indexing. Because the index has sorted, it’s time to save the specified range is continuous; the query can be used to sort the index to speed up query time, thus reducing waiting time.

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    Be sure about what you want to index

    Definition of the index primary key columns, we must index them. Because the primary key can accelerate, locate a row in the table. The role of combination of the index, you can make on the speed doubled. If the employee information table, we tend to staff number is set as the primary key. Because it will not only improve on the speed, but also because the only record the primary key requirement, you can also ensure that staff numbers is unique. At this point, if then the employee number field is set to index through the employee numbers to query employee information, and its efficiency is much higher than the index has not established.

  6. #6
    Join Date
    Oct 2005
    Posts
    2,393

    For some special data types, do not index

    In the table, some fields are special. Such as a text field (TXT), image type field (IMAGE) and so on. If the fields in the table belonging to these data types, it is best not to index them. Since these fields have some common characteristics. Such as the length of the uncertainty, or very long, a few characters; or is the empty string. Text data type, such as application systems often used for Notes database table in the data type. Sometimes Notes is very long, but sometimes there is no data. If this type of field to create an index, it does not work. On the contrary, it increased the burden on the system.

Similar Threads

  1. how to manage vpn connection with IBM server 2008
    By vibs10 in forum Networking & Security
    Replies: 1
    Last Post: 23-08-2011, 04:06 PM
  2. How to manage multiple server domains?
    By Unnati! in forum Networking & Security
    Replies: 6
    Last Post: 10-06-2011, 10:44 AM
  3. How to effectively manage a good FTP server
    By Aashirya in forum Networking & Security
    Replies: 5
    Last Post: 25-03-2010, 03:32 AM
  4. How to manage remote server in Windows Server 2003
    By Akaashath in forum Networking & Security
    Replies: 5
    Last Post: 12-03-2010, 05:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,637,134.39690 seconds with 17 queries