<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Yes, the index creation is immediate.
It is most likely that <br>
<ol>
<li>your query is not using the index (look at the plan)</li>
<li>your index is not specific enough.<br>
</li>
</ol>
Solutions<br>
<ol>
<li>If you have two indexes that could be used (looking the
where or order by clause) then firebird will use the index
with the best selectivity. You may have to rebuild the
indexes to fix the selectivity if its wrong. Or change your
where clause - you put in dummy clauses to coax it.</li>
<li>Maybe you need a multi-field index. Also note that firebird
will use the fields with fixed (non range/between) values to
determine the index to use first. <br>
</li>
</ol>
<p><br>
Post your query and the index you are trying to use.<br>
</p>
<p>Rohit<br>
</p>
<br>
On 29/10/2012 9:26 a.m., John Bird wrote:<br>
</div>
<blockquote cite="mid:47C875F66BF14B15AB1BB7728A1E0B8D@JohnSony2"
type="cite">
<div dir="ltr">
<div style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE:
12pt">
<div>Firebird V2</div>
<div> </div>
<div>I have a large table (5,500,000+ records) that I just
added an index to to speed some queries. So far it has not
made much difference – is the existing data indexed
immediately on creating the index?</div>
<div> </div>
<div style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE:
12pt">John Bird<br>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>