# Which is the best way to create types in terms of performance in elasticsearch

**URL:** <https://discuss.elastic.co/t/which-is-the-best-way-to-create-types-in-terms-of-performance-in-elasticsearch/23222>\
**Category:** Elasticsearch\
**Created:** [April 14, 2015, 4:19am UTC](https://discuss.elastic.co/t/which-is-the-best-way-to-create-types-in-terms-of-performance-in-elasticsearch/23222 "2015-04-14T04:19:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![binu](https://avatars.discourse-cdn.com/v4/letter/b/3ab097/32.png) [@binu](https://discuss.elastic.co/u/binu)\
**Post date:** [April 14, 2015, 4:19am UTC](https://discuss.elastic.co/t/which-is-the-best-way-to-create-types-in-terms-of-performance-in-elasticsearch/23222/1 "2015-04-14T04:19:20Z")

</div>

i have a RDBMS tables having multiple columns and its hetrogenous and need  
to create an index in elasticsearch from these tables. So which is the best  
practise intems of creation of types in elasticsearch. i was thinking about  
the multiple option 1) create types as same as rdbms tables and add  
documents as same as records in table 2) create a type with two fileds, in  
which one of the field for identification of that document and other field  
will be the concatenation of tables columns vales. So in this way only two  
fileds will be there across the all tables and search on the one field.

So could you let me know, which is the best way to create the types. please  
let me know, if need more info.

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/ff801563-1a96-45e5-8c7d-e67f47ae1269%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/ff801563-1a96-45e5-8c7d-e67f47ae1269%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![binu](https://avatars.discourse-cdn.com/v4/letter/b/3ab097/32.png) [@binu](https://discuss.elastic.co/u/binu)\
**Post date:** [April 14, 2015, 11:10am UTC](https://discuss.elastic.co/t/which-is-the-best-way-to-create-types-in-terms-of-performance-in-elasticsearch/23222/2 "2015-04-14T11:10:51Z")

</div>

Could anybody let me know the suggestion 🙂

On Tuesday, April 14, 2015 at 9:49:20 AM UTC+5:30, binu wrote:

> i have a RDBMS tables having multiple columns and its hetrogenous and need  
> to create an index in elasticsearch from these tables. So which is the best  
> practise intems of creation of types in elasticsearch. i was thinking about  
> the multiple option 1) create types as same as rdbms tables and add  
> documents as same as records in table 2) create a type with two fileds, in  
> which one of the field for identification of that document and other field  
> will be the concatenation of tables columns vales. So in this way only two  
> fileds will be there across the all tables and search on the one field.
> 
> So could you let me know, which is the best way to create the types.  
> please let me know, if need more info.

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/e5bc26b1-0cf6-43fb-aca2-edf35f55967b%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e5bc26b1-0cf6-43fb-aca2-edf35f55967b%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:19am UTC](https://discuss.elastic.co/t/which-is-the-best-way-to-create-types-in-terms-of-performance-in-elasticsearch/23222/3 "2017-07-06T00:19:56Z")

</div>