Hibernate Community • View topic - Performance and column aliasing

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Performance and column aliasing

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

vij123456

Post subject: Performance and column aliasing

Posted: Mon Apr 06, 2009 5:03 pm

Newbie

Joined: Mon Apr 06, 2009 4:32 pm
Posts: 4

Hi,

I see that hibernate by default generates sqls with column alias ..

for eg"

"select id as id_01 from table tb_01 "..

Is there any performance concern because of this aliasing in real world queries?

Top

aantoxa

Post subject:

Posted: Tue Apr 07, 2009 2:39 am

Newbie

Joined: Mon Apr 06, 2009 9:55 pm
Posts: 12

Hi vij123456,

As far I am aware, it is recommended to use table aliases always in Oracle SQLs. Especially if they are used in PL/SQL.

However table aliases in simple SQL (having one table) do not affect parsing performance.

For SQLs which have multiple tables joined, it is even better performance-wise to use table aliases.

Regards,
Anton

Top

paulhibernate

Post subject:

Posted: Tue Apr 07, 2009 3:45 am

Newbie

Joined: Tue Apr 07, 2009 3:39 am
Posts: 1

Hi,

Alias is just a name and is there for better readability of
code. No performance issues with alias names.

Thanks
Paul

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum