Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

Thread: Survery DB Schema

  1. #16
    Join Date
    May 2004
    Location
    Boston, MA
    Posts
    19
    Huh... that's shame. You were right. With those queries, it showed discrepancy. It marked such a good performance.... shame.....

    Anyway, I'll leave this out for now.

  2. #17
    Join Date
    Feb 2003
    Posts
    1,048
    Yes, it did show a considerable performance improvement when I looked at the estimated execution plan for the queries. It was a performance cost of about 66% Table1, 34% Table2

    However, I put indexes on the data_value field in both tables, and the execution plan changed to be 50% for each. Proper indexing greatly improved the performance of Table1, but not so much for Table2.

Posting Permissions

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