Hi I have table that has huge records. This is killing the performance of stored procedure's and function's. I decided to partion the table. Will this affect any kind of coding in the stored procs or functions?
Asked
Active
Viewed 379 times
0
-
Which RDBMS are you using - SQLServer or MySQL (or something else)? – Mar 22 '12 at 09:47
-
1How have you concluded that partitioning will improve performance? – Martin Smith Mar 22 '12 at 10:22
-
SQL Server 2008 . Its not a conclusion. we are actually thinking of it. – Karbas Mar 22 '12 at 11:16
-
[You might find this answer useful then](http://stackoverflow.com/a/5109333/73226) – Martin Smith Mar 22 '12 at 14:13
1 Answers
0
You didn't write about your database engine, but generally table pertioning doesn't affect on stored proc and function code.
Will it improve yout perfomance - it depends on your query and table structure.
ceth
- 44,198
- 62
- 180
- 289