OraFAQ Forum: Performance Tuning » CAN WE USE HINT IN VIEW QUERY STATEMENT

Home » RDBMS Server » Performance Tuning » CAN WE USE HINT IN VIEW QUERY STATEMENT

Thu, 02 August 2007 09:55

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

PLS TELL ME
CAN WE USE HINT IN VIEW QUERY STATEMENT IF YES THEN HOW

JAI

Thu, 02 August 2007 10:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

If you meant INDEX HINT then.
some thing like this.

SQL>  create view my_view
  2  as
  3   select /*+ INDEX(CITY_PK_IDX)*/ CITY_CODE,COUNTRY_CODE,CITY_NAME
  4   from city;

View created.

Thu, 02 August 2007 13:00

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

DON'T WRITE YOUR POST IN CAPITALS.

Regards
Michel

Previous Topic:	How to Generate Statistics of a table and how to see in oracle 10g
Next Topic:	query tuning

Goto Forum:

]

Current Time: Fri Jun 28 06:22:39 CDT 2024