Query/Code change after Partition

• Newbiee

  Newbie

  Points: 7

  More actions

  December 3, 2010 at 7:27 am

  #104011

  Hi,

  We are planning to Partition some of the tables in a database. there are millions of records in them, the record count is growing very fast and also we have too many read/writes on them.

  do we need to change SQL queries/code after data partition? or will the existing queries [queries before partition] will work fine.

  What query changes are required.?

  please advise.

  Thanks,

• GSquared

  SSC Guru

  Points: 260824

  More actions

  December 3, 2010 at 8:28 am

  #1258438

  I don't think you'll have to change code at all. That's kind of the whole point of partitioning a table.

  Test it in your Dev/Proof of Concept environment.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon