Home > ASE, Developement > Performance Tuning – Good For Developers – Part 2

Performance Tuning – Good For Developers – Part 2

Scene 1 — If you are suppossed to search range of values then use clustered index because in range search values will be at consecutive location in sorted order after clustered index creation. So effort for engine would be reduced.

Scene 2 — Use stored procedure instead of individual queries because
– It reduces the network traffic
– Query plan got created once for same query which could be re-used instead of creating again and again.
– Stored procedure can be invoked by passing different parameters instead of sending newly created query again and again.

Scene 3 – Make sure there are no table scan on large tables.

Check the Sybase Wiki @ sybasewiki.com
Categories: ASE, Developement Tags: ,
  1. Siddan
    December 28th, 2010 at 14:59 | #1

    Good tips. Small but really helpful. Bring on more.

  1. No trackbacks yet.