DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: update is not slow with bitmap index

Threaded View

  1. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    2 min may not seem big improvement.
    BTW, i was asking to test with a table with millions of records not with millions looping update.
    The reason why you should not compare the result
    1. If Table got less amount of data
    2. The table has only 3 columns,Only 3 columns, that means less space for physical storage. If you simulate with some kind of real time table, i think you'll able to gain more time.
    Last edited by malay_biswal; 12-28-2007 at 01:41 AM.
    http://www.perf-engg.com
    A performance engineering forum

Posting Permissions

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


Click Here to Expand Forum to Full Width