Partitioned Index on a non partitioned table ?

Hi All,
Is it possible to create a partitioned index on a table which is not partitioned? If so what is such a partition called and please explain?
I have done some research on partitions and index partitions and this is where I hit the wall the 2nd time. As per my study there are 3 types of indexed partitions: Global index (which is on an entire partitioned table) then there is Local Index (on just the partition of the table) and then there is a non-partitioned index (over a non partitioned table).
Finally there is a subdivision of the Global index which is a Global Partitioned Index (A global index with a different index key then that of the table). But I also couldn't understand what a Global Non-Partitioned Index does on an indexed table? Does it mean, its a Global Index which is not partitioned on a partitioned table ?
Regards,
Aj

Mar 14 '09 #1

Subscribe Post Reply

13362

amitpatel66

2,367

Expert 2GB

Check here for detail

Mar 16 '09 #2

eeriehunk

thanks dude, I appreciate it...
AJ

Mar 17 '09 #3

by: srinik | last post by:

Guy’s, Adding Index to Table may reduce performance of Some Select? Thanks in advance, Srini

Oracle Database

Corrupt Primary Key index on table causing ORA-600 internal error

by: Thiko | last post by:

Hi I have a corrupt PK index on a table column. It is a unique PK. It needs to be dropped and recreated to cure the corruption. The table is on a backup database which is in replication...

Oracle Database

Quale tipo di indice sulla tabella? Wich kind of index on table..??

by: STB | last post by:

ciao a tutti... ci risono... devo migliorare delle performance di accesso ad una tabella... la tabella non ha indice primario, ne altri indici... sulla tabella ci accedo con select di questo...

Microsoft SQL Server

Get the table row index from table DOM2

by: sudhaoncyberworld | last post by:

Hi all I have n tr elements in my table. i want to insert some tr in b/w trs. so i know only row id of particular row( ex: n) and i want to insert at n+1th position. So i want to find out the...

Javascript

ie6 Insert Row at specific Row Index of Table

by: Giggle Girl | last post by:

Can someone show me how to insert a row at any given row index of an already created table? It only has to work in IE6 (used on intranet at work). Specifically, if a table is 20 rows in total...

Javascript

How to get row index of table layout control?

by: nirmalsingh | last post by:

hi all, how to get row index of table layout control in c#.net 2005.(windows application) thanx in advance With Cheers Nirmal

.NET Framework

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Partitioned Index on a non partitioned table ?

Similar topics