Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

13 The X$ Tables (Advanced DBA) > Using Hints with X$ Tables and Indexes

Using Hints with X$ Tables and Indexes

As with other tables, you can also use hints with the X$ tables to achieve greater performance. The queries in the next two listings show the explain plan and statistics while changing the driving table using an ORDERED hint. Note that I am using aliases for the tables and would need to hint the alias (and not the table) if I used a hint requiring the table (such as the index hint). The ORDERED hint does not require the table name but accesses tables in the order listed in the FROM clause.

Forcing the X$KSBDP table as the driving table

select   /*+ ordered */ p.ksbdppro, p.ksbdpnam,
         d.ksbdddsc,p.ksbdperr
from     X$ksbdd d, X$ksbdp p
where    p.indx = d.indx;

Image

Using the ordered hint to force the driving table to be X$KSBDP


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint