<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt">Hello, I guess a very basic question.<br><br>In the following example: from http://search.cpan.org/~mstrout/DBIx-Class-0.08202/lib/DBIx/Class/ResultSet.pm<br><br><br><pre class="sh_perl sh_sourceCode">  <span class="sh_keyword">my</span> <span class="sh_variable">@cds</span>    <span class="sh_symbol">=</span> <span class="sh_variable">$cd_rs</span><span class="sh_symbol">-&gt;</span><span class="sh_function">search</span><span class="sh_symbol">(</span><span class="sh_cbracket">{</span> year <span class="sh_symbol">=&gt;</span> <span class="sh_number">2001</span> <span class="sh_cbracket">}</span><span class="sh_symbol">);</span> <span class="sh_comment"># "... WHERE year = 2001"</span>
  <span class="sh_keyword">my</span> <span class="sh_variable">$new_rs</span> <span class="sh_symbol">=</span> <span class="sh_variable">$cd_rs</span><span class="sh_symbol">-&gt;</span><span class="sh_function">search</span><span class="sh_symbol">(</span><span class="sh_cbracket">{</span> year <span class="sh_symbol">=&gt;</span> <span class="sh_number">2005</span> <span class="sh_cbracket">}</span><span class="sh_symbol">);<br><br>are we to understand that, table is 'indexed' or at least has a unique constraint on the column year? or can I do a search on non-index, non-constrained, just a normal column?<br><br>thank you.<br>Rajeev<br></span></pre><br><div><br></div></div></body></html>