multiple index hints format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: multiple index hints format

  1. #1
    Join Date
    Jun 2003
    Posts
    132

    multiple index hints format

    Hi,

    Can someone please confirm this for me?

    I would like to use mutliple index hints in my select statement, but I am not sure of the proper formatting.

    SELECT /*+ Index(A some index), Index (B some inde) */

    Is this the correct format? Do I need to use the comma?

    Thanks

    Roman

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, no commas between various hints.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    After checking the documentation I realized that apparently it doesn't matter wethere you use commas between the hints or not - Oracle will correctly interpret both hints as such even if there is a comma between them. Documentation states that the synax for hints is:
    Code:
    {DELETE|INSERT|SELECT|UPDATE} /*+ hint [text] [hint[text]]... */
    So the comma between the two hints will be interpretted as an ordinar comment text between the first and the second hint. I'm only not sure wether there must be a space between the first hint and the comma or not (reading the above sintax very strictly there shoul×d be a space between the hint and any following comment text, but I'm not sure abot that.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width