<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <br>
    <div class="moz-cite-prefix">On 4/21/15 2:47 AM, Ajaya Agrawal
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAGncKO48kNtGPm6me5V1DWyCa7wG9J+Ftu=emNhy_2me5m_E+g@mail.gmail.com"
      type="cite">
      <div dir="ltr">Hi All,
        <div><br>
        </div>
        <div>I see that glance supports arbitrary sort parameters and
          the default is "created_at" while listing images. Is there any
          reason why we don't have index over these fields? If we have
          an index over these fields then we would avoid a full table
          scan to do sorting. IMO at least the created_at field should
          have an index on it.</div>
      </div>
    </blockquote>
    just keep in mind that more indexes will place a performance penalty
    on INSERT statements, particularly at larger volumes.  I have no
    idea if that is important here but something to keep in mind.<br>
    <br>
    <br>
    <br>
    <br>
    <blockquote
cite="mid:CAGncKO48kNtGPm6me5V1DWyCa7wG9J+Ftu=emNhy_2me5m_E+g@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div><br>
        </div>
        <div>
          <div>
            <div class="gmail_signature">
              <div dir="ltr">
                <div>Cheers,<br>
                </div>
                Ajaya<br>
              </div>
            </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: <a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev-request@lists.openstack.org?subject:unsubscribe">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>