# ActiveRecord methods to work with indexes?

**URL:** <https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990>\
**Category:** Rails\
**Created:** [April 16, 2008, 9:36pm UTC](https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990 "2008-04-16T21:36:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ericgoodwin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/c68b51/32.png) [@ericgoodwin](https://www.ruby-forum.com/u/ericgoodwin)\
**Post date:** [April 16, 2008, 9:36pm UTC](https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990/1 "2008-04-16T21:36:50Z")

</div>

Do ActiveRecord have any functions to work with indexes.

For example, say I had

class Book \< ActiveRecord::Base  
end

Book.indexes =\> [“idx\_on\_creator\_id”, “idx\_on\_somethingelse”]

Book.index\_on(“creator\_id”) =\> “idx\_on\_creator\_id”

Anything like this around?

---

<div class="post-metadata">

**Author:** ![ericgoodwin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/c68b51/32.png) [@ericgoodwin](https://www.ruby-forum.com/u/ericgoodwin)\
**Post date:** [April 16, 2008, 10:11pm UTC](https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990/2 "2008-04-16T22:11:46Z")

</div>

On Apr 16, 8:36 pm, Aryk G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> Do ActiveRecord have any functions to work with indexes.

Just what’s available in migrations IIRC.

Fred

---

<div class="post-metadata">

**Author:** ![ericgoodwin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/c68b51/32.png) [@ericgoodwin](https://www.ruby-forum.com/u/ericgoodwin)\
**Post date:** [April 16, 2008, 10:42pm UTC](https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990/3 "2008-04-16T22:42:29Z")

</div>

Frederick C. wrote:

> On Apr 16, 8:36�pm, Aryk G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> wrote:
> 
> > Do ActiveRecord have any functions to work with indexes.
> 
> Just what’s available in migrations IIRC.
> 
> Fred

whats migrations IIRC?

---

<div class="post-metadata">

**Author:** ![ericgoodwin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/c68b51/32.png) [@ericgoodwin](https://www.ruby-forum.com/u/ericgoodwin)\
**Post date:** [April 17, 2008, 12:38am UTC](https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990/4 "2008-04-17T00:38:39Z")

</div>

> Book.index\_on(“creator\_id”) =\> “idx\_on\_creator\_id”  
> yeah you can create a migration that does something like  
> add\_index :table, :column # or create\_index or something

---

<div class="post-metadata">

**Author:** ![ericgoodwin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/c68b51/32.png) [@ericgoodwin](https://www.ruby-forum.com/u/ericgoodwin)\
**Post date:** [April 16, 2008, 10:55pm UTC](https://www.ruby-forum.com/t/activerecord-methods-to-work-with-indexes/134990/5 "2008-04-16T22:55:56Z")

</div>

On Apr 16, 9:42Â pm, Aryk G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> Frederick C. wrote:
> 
> > On Apr 16, 8:36�pm, Aryk G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> > wrote:
> > 
> > > Do ActiveRecord have any functions to work with indexes.
> 
> > Just what’s available in migrations IIRC.
> 
> > Fred
> 
> whats migrations IIRC?  
> IIRC = If I remember correctly.

Fred