Results 1 to 3 of 3

Thread: Composite key query optimization

  1. #1
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,730

    Composite key query optimization

    I've been doing some work on the SQL query optimizer quietly in every release of the product.

    The optimizer already handles partial key index restriction and composite keys. The optimizer will also use filtered indexes if they match the query.

    In v1.4.1 composite keys that may have some functions in them that convert the data type of a column are also taken into consideration.

    Here are a few screenshots to show you the sort of performance I'm now seeing on > 1m record tables.

    Name:  Screen Shot 2015-03-18 at 2.11.01 PM.jpg
Views: 72
Size:  94.7 KB

    Name:  Screen Shot 2015-03-18 at 2.12.54 PM.jpg
Views: 73
Size:  66.9 KB
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  2. #2
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,862
    Great performance!
    Great Barry.

    ciao
    Fabio

  3. #3
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,934
    Good job!

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us