oracle中no_index的使用,多个表no_index提示怎么写？

SQL> select  count(*) from a1,a2,a3

2  where a1.object_id=1

3  and a2.object_id=1

and a3.object_id=1

and a1.object_name=a2.object_name

and a1.object_name=a3.object_name;

4    5    6

COUNT(*)

----------

0

Execution Plan

----------------------------------------------------------

Plan hash value: 2371692280

-----------------------------------------------------------------------------------------

| Id  | Operation                       | Name  | Rows  | Bytes | Cost (%CPU)| Time     |

-----------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                |       |     1 |    66 |     6   (0)| 00:00:01 |

|   1 |  SORT AGGREGATE                 |       |     1 |    66 |            |          |

|*  2 |   TABLE ACCESS BY INDEX ROWID   | A3    |     1 |    22 |     2   (0)| 00:00:01 |

|   3 |    NESTED LOOPS                 |       |     1 |    66 |     6   (0)| 00:00:01 |

|   4 |     NESTED LOOPS                |       |     1 |    44 |     4   (0)| 00:00:01 |

|   5 |      TABLE ACCESS BY INDEX ROWID| A1    |     1 |    22 |     2   (0)| 00:00:01 |

|*  6 |       INDEX RANGE SCAN          | A1IDX |     1 |       |     1   (0)| 00:00:01 |

|*  7 |      TABLE ACCESS BY INDEX ROWID| A2    |     1 |    22 |     2   (0)| 00:00:01 |

|*  8 |       INDEX RANGE SCAN          | A2IDX |     1 |       |     1   (0)| 00:00:01 |

|*  9 |     INDEX RANGE SCAN            | A3IDX |     1 |       |     1   (0)| 00:00:01 |

-----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

2 - filter("A1"."OBJECT_NAME"="A3"."OBJECT_NAME")

6 - access("A1"."OBJECT_ID"=1)

7 - filter("A1"."OBJECT_NAME"="A2"."OBJECT_NAME")

8 - access("A2"."OBJECT_ID"=1)

9 - access("A3"."OBJECT_ID"=1)

Statistics

----------------------------------------------------------

1  recursive calls

0  db block gets

2  consistent gets

0  physical reads

0  redo size

514  bytes sent via SQL*Net to client

492  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SQL>

SQL> select /*+ no_index(a1) no_index(a2) no_index(a3)+*/ count(*) from a1,a2,a3

2  where a1.object_id=1

3  and a2.object_id=1

and a3.object_id=1

and a1.object_name=a2.object_name

and a1.object_name=a3.object_name;  4    5    6

COUNT(*)

----------

0

Execution Plan

----------------------------------------------------------

Plan hash value: 2321433088

-------------------------------------------------------------------------------

| Id  | Operation              | Name | Rows  | Bytes | Cost (%CPU)| Time     |

-------------------------------------------------------------------------------

|   0 | SELECT STATEMENT       |      |     1 |    66 |   107   (2)| 00:00:02 |

|   1 |  SORT AGGREGATE        |      |     1 |    66 |            |          |

|*  2 |   HASH JOIN            |      |     1 |    66 |   107   (2)| 00:00:02 |

|   3 |    MERGE JOIN CARTESIAN|      |     1 |    44 |    71   (2)| 00:00:01 |

|*  4 |     TABLE ACCESS FULL  | A2   |     1 |    22 |    36   (3)| 00:00:01 |

|   5 |     BUFFER SORT        |      |     1 |    22 |    36   (3)| 00:00:01 |

|*  6 |      TABLE ACCESS FULL | A3   |     1 |    22 |    36   (3)| 00:00:01 |

|*  7 |    TABLE ACCESS FULL   | A1   |     1 |    22 |    36   (3)| 00:00:01 |

-------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

2 - access("A1"."OBJECT_NAME"="A2"."OBJECT_NAME" AND

"A1"."OBJECT_NAME"="A3"."OBJECT_NAME")

4 - filter("A2"."OBJECT_ID"=1)

6 - filter("A3"."OBJECT_ID"=1)

7 - filter("A1"."OBJECT_ID"=1)

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

157  consistent gets

0  physical reads

0  redo size

514  bytes sent via SQL*Net to client

492  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed