Solved

Indexing Columns

Posted on 1999-01-18
1
263 Views
Last Modified: 2013-12-18
How do you index a column in Notes so that your query will run faster in say Crystal Reports.
0
Comment
Question by:paulca
1 Comment
 
LVL 2

Accepted Solution

by:
phooey earned 10 total points
ID: 1117918
Indexing columns in Notes is simply a matter of sorting the column.  Make sure you also set the view property to include Unique Indexes for ODBC access.
One thing worth noting is that the size of the view is related to the number of indexes and therefore the number of sorted and categorised columns.
There is a limit to the size of views (in help - search for Notes limits) and the perfromance of them decreases pretty much exponentially as you get anywhere near this limit.  You can check the size in the server log.
Because of this you might find that you are better creating specific, one column hidden views for your queries.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now