udai's

Tuesday, 19 August 2014

Tuning Tidbits


  1. can avoid sort by in exectuion plan ,by including that column in index,so that it will get sorted in index itself so no need to sort again

Posted by udai at 07:20
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database, Optimization

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Search This Blog

Labels

  • BigData (1)
  • Categoreis (1)
  • Database (6)
  • May 2014 at &K (1)
  • Optimization (1)
  • useful queries (2)
  • welcome 2012 (1)

Blog Archive

  • ►  2018 (33)
    • ►  April (12)
      • ►  Apr 21 (3)
      • ►  Apr 15 (3)
      • ►  Apr 09 (1)
      • ►  Apr 08 (2)
      • ►  Apr 07 (1)
      • ►  Apr 06 (2)
    • ►  March (4)
      • ►  Mar 15 (2)
      • ►  Mar 14 (1)
      • ►  Mar 13 (1)
    • ►  February (17)
      • ►  Feb 28 (2)
      • ►  Feb 26 (1)
      • ►  Feb 25 (1)
      • ►  Feb 23 (1)
      • ►  Feb 22 (2)
      • ►  Feb 19 (1)
      • ►  Feb 17 (2)
      • ►  Feb 10 (2)
      • ►  Feb 07 (2)
      • ►  Feb 05 (1)
      • ►  Feb 04 (1)
      • ►  Feb 03 (1)
  • ►  2017 (2)
    • ►  July (2)
      • ►  Jul 03 (2)
  • ►  2016 (2)
    • ►  April (2)
      • ►  Apr 21 (1)
      • ►  Apr 20 (1)
  • ▼  2014 (9)
    • ►  November (1)
      • ►  Nov 16 (1)
    • ►  October (1)
      • ►  Oct 17 (1)
    • ▼  August (5)
      • ▼  Aug 19 (2)
        • Tuning Tidbits
        • Sql Queries
      • ►  Aug 18 (2)
      • ►  Aug 13 (1)
    • ►  May (2)
      • ►  May 10 (2)
  • ►  2012 (1)
    • ►  October (1)
      • ►  Oct 02 (1)
  • ►  2011 (2)
    • ►  December (1)
      • ►  Dec 30 (1)
    • ►  July (1)
      • ►  Jul 05 (1)

About Me

udai
View my complete profile
Travel theme. Powered by Blogger.