Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdppt\tdppt_sqlopt006.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Using a Hypothetical Workload</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-05-27T15:13:3Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Using a Hypothetical Workload" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10822-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdppt_sqlopt005.htm" title="Previous" type="text/html" /> <link rel="next" href="tdppt_sqlopt007.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdppt_sqlopt005.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlopt007.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHCJHIH" name="CIHCJHIH"></a><a id="TDPPT177" name="TDPPT177"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Using a Hypothetical Workload</h1> <a name="BEGIN" id="BEGIN"></a> <p>A <span class="bold">dimension table</span> stores all or part of the values for a logical dimension in a star or snowflake schema. You can create a hypothetical workload from dimension tables containing primary or foreign key constraints. This option is useful if the workload to be analyzed does not exist. In this case, SQL Access Advisor examines the current logical schema design, and provides recommendations based on the defined relationships between tables.</p> <p class="orderedlisttitle">To use a hypothetical workload as the workload source: </p> <ol> <li> <p>On the SQL Access Advisor: Workload Source page, select <span class="bold">Create a Hypothetical Workload from the Following Schemas and Tables</span>.</p> </li> <li> <p>Leave <span class="bold">Schemas and Tables</span> empty and then click <span class="bold">Add</span> to search for tables.</p> <p>The Workload Source: Search and Select Schemas and Tables page appears.</p> </li> <li> <p>In the Tables section, enter a schema name in the <span class="bold">Schema</span> field and then click <span class="bold">Search</span>.</p> <p>A list of tables in the selected schema is displayed.</p> </li> <li> <p>Select the tables to be used in creating the hypothetical workload and then click <span class="bold">Add Tables</span>.</p> <p>The selected tables now appear in the <span class="bold">Schemas and Tables</span> field.</p> </li> <li> <p>Click <span class="bold">OK</span>.</p> <p>The SQL Access Advisor: Workload Source page appears with the selected tables now added.</p> </li> <li> <p>Proceed to the next step, as described in <a href="tdppt_sqlopt007.htm#CIHEAEJC">"Running SQL Access Advisor: Filter Options"</a>.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=CNCPT411','newWindow').focus()"><span class="italic">Oracle Database Concepts</span></a> for an overview of materialized views</p> <p><a href="tdppt_sqlopt001.htm#BABHDIFI">Running SQL Access Advisor</a></p> <p><a href="tdppt_sqlopt003.htm#CIHHEEFH">Running SQL Access Advisor: Workload Source</a></p> </div> </div> <!-- class="sect3" --> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdppt_sqlopt005.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdppt_sqlopt007.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de