Solved

Indexing Columns

Posted on 1999-01-18
1
264 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 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

10 Experts available now in Live!

Get 1:1 Help Now