Home » RDBMS Server » Performance Tuning » CAN WE USE HINT IN VIEW QUERY STATEMENT
CAN WE USE HINT IN VIEW QUERY STATEMENT [message #255958] Thu, 02 August 2007 09:55 Go to next message
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
Re: CAN WE USE HINT IN VIEW QUERY STATEMENT [message #255965 is a reply to message #255958] Thu, 02 August 2007 10:20 Go to previous messageGo to next message
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.

Re: CAN WE USE HINT IN VIEW QUERY STATEMENT [message #256000 is a reply to message #255958] Thu, 02 August 2007 13:00 Go to previous message
Michel Cadot
Messages: 64153
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: Sun Dec 11 08:01:12 CST 2016

Total time taken to generate the page: 0.09788 seconds