User habits that hurt performance

Perform search with incorrect index
Proof: compare performance when searching Document No. on G/L Entry table between using "Document No." index and "Entry No."

Navision read performance on a big table is very slow
www.mibuso.com/forum/viewtopic.php?f=34&t=24392

Find in NAV : performance
http://mibuso.com/blogs/kriki/2010/10/03/find-in-nav-performance/

Search on any part of the field
www.mibuso.com/forum/viewtopic.php?f=32&t=42201&p=206960

Q: Can we prevent users from doing search on certain fields?
Keyword: disable|prevent search|find certain|arbitrary column|field
A: Set Focusable property of the field/column in question to No
Side-effect on List: User can't use his keyboard to jump over the 'restricted' field
Still problem: User can still perform "Field Filter" on that field