Results 1 to 2 of 2

Thread: urgent

  1. Jul 22nd, 2003, 11:02 AM #1
    manu487
    manu487 is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2002
    Posts
    174

    urgent

    Hi all,
    I know that while we r using the property "Indexing" in the database then searching becomes fast and updation becomes slow. my question is why? then how we use the property for search and save?
    Reply With Quote Reply With Quote
  2. Jul 23rd, 2003, 03:00 AM #2
    dj4uk
    dj4uk is offline
    Frenzied Member dj4uk's Avatar
    Join Date
    Aug 2002
    Location
    Birmingham, UK Lobotomies: 3
    Posts
    1,131
    By indexing a field the database in the background indexes all the data stored in that field. You don't really need to know what it does just that it does it. Once a field is indexed then the database will be able to search the field quicker as it has an index to look up (think of indexes in books). The reason it takes long to update a field is because once indexed a field must have the actual field updated along with the index associated with it. To use indexes you don't need to do anything different (at least thats my experience with SQL server) by just being indexed it does the job.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width