Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Indexing Columns

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
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.

809 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