Named Native Query Vs Native Query Vs HQL / JPQL

there are some missing up with understanding the difference between the Native Named Query and Native Query and HQL , and a lot of headache about the the performance issue in using them.

What is the Difference between Native Query and Named Native Query :

here I will give a short notice about the difference between them

Native Query : the developer is writing a native SQL query. and has and i'ts dynamic query , it's compiled and execute in run time and will be validated each time the query is executed.

Name Native Query : the scope is persistence  ontext and can be used in the application by Specifying the Identity , and it is ready defined and Compiled once , and it's of course static statement.

they are validated only once, at the server startup

Regarding the Difference between HQL statements and Native Statements 

Native SQL is not necessarily faster than HQL. HQL finally also is translated into SQL (you can see the generated statement when running the application with the show_sql property set to true).

In some cases it can happen Hibernate / JPA  does not generate the most efficient statements, so then native SQL can be faster 

Pros and Cons Of using HQL :

Pros: 

•  Hibernate/JPA handle the intricacies of converting the HQL into the various SQL dialects( if you write native SQL , you will lose the portability from DB to another and need to change your statements.because)
• with native SQL you're missing the Hibernate cache - as a consequence in some cases native SQL can be slower than HQL.

Cons:

• In some cases it can happen Hibernate / JPA  does not generate the most efficient statements, so then native SQL can be faster

What are the main differences between HQL/JPQL and Criteria ?

HQL is to perform both select and non-select operations on data, Criteria is only for selecting data, we can’t perform non-select operations using criteria. Criteria takes more time to execute than HQL. With Criteria we are safe with SQL injection, because of its dynamic query operation, but in HQL as your queries are either fixed or parametrized , there is no safe for SQL injection. Criteria Api allows compile time checking of a query.