Re: Use of hints

From: Sergei Didur <sdidur_at_notes.cc.bellcore.com>
Date: 1997/11/21
Message-ID: <01bcf6cc$955331f0$79a06080@sdidur-1>#1/1

You should put hints in comments after SELECT keyword:

SELECT --+ RULE
*
FROM some

-- 
Sergei Didur

Satish Narasimha <satishn_at_blr.sni.de> wrote in article
<34752260.5349_at_blr.sni.de>...


> hello,

>     Can anybody say me how to hints in optimisation of a query with 

>     some small e.g.

> 

>     I know that hints can be used, but don't know how to use, can

>     anybody help how to solve this problem ?

> 

>     Thanks in advance and shall be waiting for the reply.

> 

> from

> satish :satishn_at_blr.sni.de

>         somasatish_at_hotmail.com

>

Received on Fri Nov 21 1997 - 00:00:00 CST