Index – Pardaan.com

Select with partially matching index: can we make it faster?

Let's assume we want to select a set of customer ledger entries based on two values: salesperson code and the payment reference. Or any subset of records from any other table that satisfies two criteria: the table is large enough, so the query can benefit from…

24 June 2024

Dynamics NAV & BC Tips & tricks

Business Central Onpremise – Create SQL Missing Indexes from AL

Through the page 9521 Database Missing Indexes it is possible to see the missing indexes suggested by SQL Server for Business Central (in fact, an SQL function is called which returns the missing indexes). In this case the same function has been recreated on SQL (stored…

16 August 2023

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: new indexing features on 2021 Wave 2 release

Dynamics 365 Business Central 2021 Wave 2 release (version 19) introduces some new indexing features that you can use on your tables definitions from AL. Now you can: - Define columnstore indexes - Define included columns in indexes Source : Stefano Demiliani Read more...

15 September 2021

Dynamics NAV & BC Tips & tricks

SQL server reorganize or rebuild indexes script v2.0

Rebuild or reindex? Good question! Analysis indexes defragmentation RATIO and decide to REORGANIZE OR REBUILD Bron : Roberto Stefanetti NAV Blog Lees meer...

2 October 2015

Dynamics NAV & BC Tips & tricks

NAV 2013 | No more Indexhinting

Well, that sounds cool right? Like, never index hinting in NAV anymore after all the discussions in the past. Bron : Mark Brummel Lees meer...

10 April 2013

Dynamics NAV & BC Tips & tricks

Table Information including Index information (Usage, Blocks and Reads) – Again

In summary: This query shows a list of all tables and indexes in a SQL database to help identifying in which tables the most blocks happen, and to give a starting point for index tuning. For further details, refer to the original blog post. Bron :…

20 February 2012