Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Create a View without Duplicates

Former Member

‎2007 Nov 27 3:22 PM

0 Likes
394

Hi all,

I need to read 3 fields on a custom tables with 27.000 entries. The result of my selection is about 150 entries, so in order to minimize time of selection I thought to create a View on this Table based on 3 fields I need.

Can I create a View which extracts my 3 fields without duplicates?

Best Regards,

Raffaele

1 REPLY 1
Read only

JozsefSzikszai
Active Contributor

‎2007 Nov 27 3:38 PM

0 Likes
302

hi Raffaele,

you can create the vierw (however views are usually created on more tables). If there will be duplicates, it only depends on what are these three fields and what values are there.

If you are not satisfied with the performance of the select statement in the program, than you can create a secondary index with these three fields in the table (I assume the WHERE conditions are also based on these fields in the program).

hope this helps

ec