db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [OPTIMIZER] Optimizer "timeout" for subqueries?
Date Fri, 03 Mar 2006 20:14:40 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Satheesh Bandaram wrote:<br>
<blockquote cite="mid44089EB1.2070209@Sourcery.Org" type="cite">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
  <ol>
    <li>Multiple index scans for one table. Extension of above to cover
cases like <b>a=2 and b=4</b> with index on both <b>a </b>and <b>b</b>.<br>
    </li>
  </ol>
</blockquote>
Oops... I meant <b>a=2 OR b=4</b> with index on both a and b.<br>
<br>
Satheesh<br>
</body>
</html>


Mime
View raw message